Print Report of different values of the same field.

  • Thread starter Thread starter TQ
  • Start date Start date
T

TQ

doCmd.OpenReport "rptListofIsssues", acViewPreview, , "[Status] = 'Closed' "

I'm supposed to print list of all closed issues and list of open issues.
The open issue can have status of 'new', 'accept', and 'deferred'. The
command above allows me to list of the closed issue on a report. How can I
list of the open issues on a report also? Can I use the same code above to
achieve this? How? Or do I have to use different way? Thank so much for
your help!
 
Hi,

I have found the answer for this in one of the posts.

so basically, I can use

doCmd.OpenReport "rptListofIsssues", acViewPreview, , _
"[Status] = 'New' Or [Status] = 'Accepted' Or [Status] = 'Deferred' "

How can I code [Status] is not Closed?

Thanks!
 
Back
Top