Recent content by RichardMc

Wonderful!! I knew there had to be a simple answer.... Thanks!!

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'm not sure about a crosstab query, but a report worked great, grouped on the unique ID field so that only 1 report page output per unique ID

A report did turn out to be the easiest solution. Thanks!

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 love it when I don't even have to post my question! A quick search, and the answer is already there! Thanks for blazing the trail...

Thanks to all of you for the input!! I took the simple way out! Following Raskew's suggestion I looked at the field type and changed it from text to Number and the leading zeros disappeared!

Thanks! But I am not sure how to use this formula. Any chance you could give me a brief example?

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

Thanks for the tip! Fullname it will be from here on in.... No point in tempting fate since 'The best laid schemes o' mice an' men Gang aft agley'

Thanks!! I actually ended up including the Trim as part of the concatenation of name fields: UPDATE Tablename SET Tablename.Name = Trim$([Firstname]) & " " & Trim$([Lastname]);

Can you give me an example of how to use it here? 'Fraid I don't know how to use it to Trim an indeterminate number of blank spaces! Thanks!

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

The Update Query worked like a charm!! And yes, I had all the data safely backed up before I started - first lesson I learned! Thanks again! Richard

This works. However when I searched for Like 'Dr*' I get 2191 records come up! (When I said small number I was referring to the various titles (Mr, Dr, Prof) rather than the instance of each.) So what I then did was to do a Replace (Using Replace on the Edit menu) Dr with _ (blank), at start of...