Omitting certain details in report

[GoDawgs]

I have a report I have created that has store numbers and sales in the details section for about 400 stores...I need the report to omit certain stores from the details section (but I still need that data in the recordsource, so I can't just take it out of there)...I am a decent programmer, but can't seem to figure out exactly when and how to skip these records, any help would be much appreciated...

Kevin

 

[CosmoKramer]

Kevin,

In your report's detail section, put code like this in the On Format event:

If Me.StoreNum= "89" Or Me.StoreNum = "90" ...etc.... Then
Cancel = True
End If

This will suppress the display of those records in the detail section.

You could also substitute a wildcard statement is that applies.....

 

[GoDawgs]

Simple enough...and exactly what I was looking for...I appreciate it...