Search results for query: *

I am looking to build a query on a number of fields in a amster table based on the "mailing codes" stored in another table. I want to pull off a list of customers in a master table (122,000) that do not have any of the codes listed in the mailing codes table. What would be the best...

I have a table that I have to select out of it all the records that have requested a brochure on their own accord (ie thay have not received a mailer). This enatils searcing all fields, to make sure there is no MAIL4, Encl Ms, etc etc. As this is a UNIX import all the fields are all over the...

I have imported a large text file (UNIX) into a table. Some of the fields have shifted etc and i have a lot of sorting to do. One key field has the email address then a limiter then booking number, as below xt@abc.fsnet.co.ukþ0000189 I need to ditch the delimiter "þ" then move the...

I have a global table that houses a huge text import. I now want to extract some of that data based on a query into another table to do some work on it. What is the best way to do this?

I have a text file as below, with over 120,000 records that my client would like to persuse with various search criteria from within Access. would appreciate views and guides on this. Each record houses address details, one copy, booking details could be numerous and brochure details again...

I am starting a project where my client wants a unix flatfile imported into access. The file contains 120,000 unique records. The records are delimited and the following format. 3801111,,,,,,,,$3801111,,,,,,,,,$3801111,,,,,,,,,,. Whereby the first record is clients name and addressetc then...