Query - omitting a record

HMC

Registered User.
Local time
Today, 15:16
Joined
Mar 14, 2007
Messages
11
Hi,

Wondered if SKS can help. I have a query which I have used for a mailing list (in report). However, there are a couple of records I do not want to show. (I just don't need those addresses at this time) How do I go about omitting these two from the query? Is this to do with crosstab queries??

Many thanks

Helen:)
 
Hi Helen,

I would add a checkbox in your table (ckInclude) with default set to Yes. Then in your table you can disable the checkbox for those people you do not want included in your mailing labels report.
The query would have to have field ckInclude with criteria = Yes.

Dave
 

Users who are viewing this thread

Back
Top Bottom