How to make more criteria in the report. (1 Viewer)

[famokad]

How to make more criteria in the report.
docmd.openreport "report name", ,criteria (more than one)

 

[Isaac]

Open report with multiple criteria (two)

i'm trying to open a report after executing a sql to save data from a form and after saving i want to open the report with the saved data so i want to open it with multiple criteria where number = same number in form and date = same date in form this is my code DoCmd.OpenReport...

www.access-programmers.co.uk

 

[theDBguy]

How to make more criteria in the report.
docmd.openreport "report name", ,criteria (more than one)

Basically, you make the criteria like you would use a WHERE clause. For example:

criteria = "Field1=Value1 AND Field2=Value2"