Search results

HI, I have a select query that is pulling data from a table containing name and address info. I need to specify criteria to pull records where the country field is NOT one of the following: null USA Mexico Canada I have tried: is not null or "USA" or "Mexico" or "Canada" but that does not...

I need to create a mail merge from an Access 2k DB to a Word 2K doc. The Access DB contains 3 tables: Attendee - name, address of people who attended courses Sessions - the details of the courses, including no. of continuing education credits for each course Signups - attendee Id and Id of...

I need to create a find unmatched query to weed out duplicate records from 2 tables. I need to use a confirmation number field that is common to both tables. However in table A, there are leading zeros, e.g. 0000004139 0000018763 In Table B there are no leading zeros, e.g. 4139 18763 Can I...

I am creating a Find Unmatched query in Access 2000. One of the tables I am comparing has blank spaces at the end of the firstname field. Before I can successfully run a find unmatched query, I need to trim out the additional spaces. The number of spaces is not constant, but varies...

Hi, I am trying to check 1 table against another for unmatched records, using a name field. In Table 1 the name field contains first and last name, e.g. John Smith. In Table 2, some (but not all) of the records also contain a title e.g. Dr John Smith. Any ideas on how to strip these titles from...