How to use 3 criterias in filtering a report using VB (1 Viewer)

[irslan rafique]

Hi,
My report(Invoice) is based on a query.
I am filtering report(on a filed 'DriversName') using following command:

DoCmd.OpenReport "Invoice", acViewPreview, , "DriversName like '*" & txtname & "*'"(working fine)

Can anybody tell me please that how to use 3 criteria or two more filters in same command.

1st Criteria: DriversName (Text)
2nd Criteria: Month (Text)
3rd Criteria: Year (Number)

Your early and prompt help will be highly appreciated.

Thanks in advance

 

[CJ_London]

Please do not double post - other thread here

http://www.access-programmers.co.uk/forums/showthread.php?t=273743

In answer to your question you use AND or OR depending on requirements

DoCmd.OpenReport "Invoice", acViewPreview, , "DriversName like '*" & txtname & "*' AND myMonth='" & txtMonth & "' AND myYear=" & txtYear

Note that month and year are reserved words and using them as field or table names can have unintended consequences