Exclude some records from report based on sku #
Posted on 2007-03-27
I have a table called WebProducts with 250-300 records. I want to exclude some records based on their product sku #.from the printed report. This list of excluded records will change from time to time. I would like to design a query that would specify which records to skip when report is printed.
Example: iif([sku#] = 'ab003' or [sku#] = 'de003',skip,print). About 5% of records will be skipped. There is no other criterea, like if [color] = 'blue'