filter report

S

s4

HI,
Is there a way to filter a report where if field [x] = 0, that record
doesn't apper on the report?
If possible I'd like to do this without a query.
Thanks
 
R

Rick Brandt

s4 said:
HI,
Is there a way to filter a report where if field [x] = 0, that record
doesn't apper on the report?
If possible I'd like to do this without a query.
Thanks
Click to expand...

DoCmd.OpenReport "ReportName", acViewPreview,,"[x] <> 0"
 
S

s4

Thanks

Rick Brandt said:
s4 said:
HI,
Is there a way to filter a report where if field [x] = 0, that record
doesn't apper on the report?
If possible I'd like to do this without a query.
Thanks
Click to expand...

DoCmd.OpenReport "ReportName", acViewPreview,,"[x] <> 0"
Click to expand...
 
Top