changeing field values

[Lewy]

I have a query that obtains all my clients within a set date range and to whom I then send a letter. What I want to do now is insert an alpha-numeric code into a field within the table to say which letter they have been sent. Can this be done within the query? Changeto won't work because a lot of the fields within the query have a check mark.

Thanks,

Lewy

 

[TonyMcGuire]

No, what you are asking requires a second query.

However, the reverse isn't true, if you can deal with ALL fields in the result.

Do a changeto query first, with all the same criteria as your are using now to get those people and with the field changed to whichever letter you are sending, and you will get the 'changed.db' result.

Use that as your criteria for sending out letters/labels/etc.

You'll get ALL fields, but just ignore the extras.

Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[Lewy]

Thanks Tony,

Having played around with it, a second query seems to be the easiest.

Regards,

Lewy