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.

Yes I have many backups I will try the new idea thanks :D

After I ran the query using the count function as a delete query it has deleted way too many records as in 40,000 to many I guess that means I cant use this as a delete query. So I have gone back to my origional query which brings me no results, Is this because when I try to click on design view...

Thanks this has worked, One more question I would also like to display the field "Last_Date" in the query but I know this is the only field that will make these records not duplicates. I want to add this as an additional field. Would I be able to turn this query into a delete query? This is...

Hello I have just run this Query to find duplicate values in my table and it has not found any this is not correct as I know there are duplicates, can anybody see what is wrong with this query SELECT DISTINCTROW [08/02VA].Load_Date, [08/02VA].Status, [08/02VA].Pack, [08/02VA].Inv_No...

Thanks I will try that

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...