View Full Version : Query - omitting a record


HMC
03-15-2007, 08:46 AM
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:)

dcobau
03-15-2007, 02:07 PM
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