Search results

I have created a form that when I click a button should run a query and create a report but I get this error msg does anybody know what it means :- Enter Parameter Value Forms!REPORT : Complaints Recieved! text0 If I press cancel I get a runtime error "2501" This works for my monthly...

Does anybody know what this could mean I am working with another persons database and trying to see how it works do not undersatnd the following DateAdd("m",-3,Date()) Is this adding a date it in the update column in the query

What kind of query would I need to run if I wanted to compare data in one table to another, e.g If Inv_no 1234 in table 1 is in Table 2 then do not export or import into table 3 Thanks

Hello I have a problems how would I write : - If Ref_no is equal to Ref_no then delete 1 of the records REF_NO 12345 REF_NO 12345 This would be a match so I would like to delete one of these records, is there a way to do this with SQL.

Is it possible to run a duplicate query on more that 10 fields as when I try to run the query it will only allow me to compare 10 fields and I have more? Thanks

I want to do the following from a table with 16000 records I would like to delete the duplicate record and keep the origional. E.g INV_NO REF_NO WT DATE 123 1234 20 19/12/80 123 1234 20...

This is a follow on to the Duplicate Query problem I did what was suggested and now I get this msg The changes you requested were not sucessful, they would create duplicate values in Index,Primary key or relationship, change data in fields. Is there maybe a way to write it in VB by saying if...

Hello, I have recently done a duplicate query on a table. It has reveled that I have 16000 duplicates. Out of the 16000 i want to delete 8000. As 8000 are valid and will be needed. ID Date Last Date 12 12/12/01 12/12/01 12 12/12/08 13/12/10 The...