filter report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter within a report 4
Access 2007 Runtime - Export Report 4
Access 2007 query (large IN statement), alternate approaches 8
Report for year to date 14
Access Access Report Works on One Machine but not Another 3
Running reports in a multiuser VB/Access environment 0
Filter in Report 2
Excel Export Filtered Form Data To Excel 0

Back
Top