How do I filter on this ?

[_Chris_]

Using MS Access (2003) quite regularly for a lot for mailshots, and when there's say a couple of hundred more address's to put on the database, I then input those address's, do the mailshot and then, to ensure that the same people don't get the same thing again, I usually apply a filter, something like a tick in the relevant column means that the person has already received something before, so don't send again!! (It's ok, all of the recipients have requested the info!).



BUT, the problem is, after each mailshot, going through the db to put the ticks in the correct column, is not too bad when there's just a few 100, but there's projects coming up, where they're in the 1,000's.

Has anyone found a way to solve this please ?

Any help much appreciated.

Chris

[jzwp11]

The best way is to use an update query, but you need some field that unique identifies the specific group of records, perhaps the date they were entered into the database?

[_Chris_]

Many thanks, that worked a treat. I got it to auto complete with todays date for every new entry.

[jzwp11]

You're welcome. Good luck with your project.

[_Chris_]

Something else that has just arisen - how can I ensure that, in the queries, any email address's containing certain words, should not be included in that query please ? I know how to do null and is not null, but not sure on this one.

Any help much appreciated.

Chris

[jzwp11]

If you are only trying to eliminate records with certain words or phrases in the text of the e-mail itself, you will need to use the LIKE operator or more precisely NOT LIKE to have the query ignore certain records. You would use this in the WHERE or criteria section of the query. The SQL text would look something like this

WHERE yourEmailFieldname NOT LIKE "*phrasetoignore*"

[_Chris_]

Excellent, many thanks - problem solved

[jzwp11]

You're welcome. Good luck with your project.