Search results

Hello I need to move an access database from one machine to another without loosing all the queries that are set up. Someone suggested that I could simply copy them from the custom.*mdb files - however I can't seem to locate where these might be! OR are there any other ways of doing this...

Hello I wondered if anyone could help me? We have an ODBC link to an Access datbase at one of our clients offices so we can run queries and pull data, we keep it on a stand alone PC which we are going to upgrade. I am trying to find ou if there is a way (without copying all the sql in to...

I have a file of data that I am using in a DM campaign. I need to add a R or a B to each record to indicate which pack the person recieves - I simply want 50% to be R and 50% to be B. I thought I could just create a table with an R and a B in it, put my data and that table in a query run it...

Hi I am trying to run a rand between function. I don't have the option to select this from the expression builder, but have found the formula in a book - RANDBETWEEN(bottom, top). However even using this it still doesn't work and I get the message "Undefined function 'randbetween' in...

I have 3 queries run from one file, they all have the same number of fields (from a large xls file i am trying to make amail file that meets 3 specific criteria). The 3 queries have worked fine but i know there are a few duplications between them. I need to join all three queries together so...

Hi I have two table linked by a URN, one table has a single date relating to each URN, the other table has multiple dates relateing to the URN. I want to to take the greatest date on the second table so that i have the largest amount of time between the two dates for each URN. Can anyone tell...