Recent content by USA_Chancer

Got it! Thanks Keith, Instead of trying to put it on the query grid, I found 'SQL Specific' under the 'query' drop down menu and simply cut and pasted your code, saved the query and ran it and it worked fine. Thanks for the help. Kind regards - Lee

Thanks Keith Thanks for your reply Keith...Can you confirm this is what I should be doing... New Query Add the two tables to the query; tblMain and tblSub Change the type of query to 'Delete Query' Grab the tblMain * to the query grid Grab the field 'Phone Number' from the tblSub to the query...

Hi all, Quick question... I have a master client table and a table of clients that have ordered from us, so don't want to be called again. I want to delete the clients record from the master table by comparing the two tables and sayi that 'everytime you find a phone number from the 'ordered'...

Got It Thx - from another forum - much simpler for anyone else who needs it...copy and paste the table structure to a new table, make the phonenumber field a primary field. use an append query to append the fields to the new table. delete the old table and rename the new. works great. hagd....

Hiya - I created this simple delete query to delete all duplicate phone numbers from a master "Do Not Call List'...However it deletes ALL versions of the number from the table, including the original. What do I have to change so that it leaves 1 version of the number in the table? thanks in...

Got It!! Thx Thx for all your help. I added that simple code in the query and it worked great! I ran a 'create a new table' query. Then deleted the un-needed fields and then deleted the original table. :D

But in a query? But in a query how do I create TextBox 1? Can i just run a 'make table' or 'update' query? in the query for my new field added can i type something in the criterea are such as an expression that: this field=[fieldname]&""&[fieldname], then run the query? its not working...

Casey? Hey Casey, Thx for your help, set its controlsource=[Area Code] & " " & [PhoneNumber] I created a new field in the main table called [allphonenumber] Then in the query I typed the above code in the criteria section for the [allphonenumber] field. It's not working, the query comes up...

Hiya everyone 1st post. If this is already answered somewhere, please just point me there...I mange large amounts of data for different companies and use Access. I have to check a lot of the lists against State "Do Not Call Lists". Anyway the latest countrywide list is over 10,000,000 records...