Solved Multiple criteria to open a report

[Capitala]

It's very confusing to use "quotes" with the docmd.openreport. Can any one please and please, provide us standard forms for:

1) Docmd.openreport,,, where NUMERIC FIELD= NUMERIC FIELD and NUMERIC FIELD= NUMERIC FIELD

2) Docmd.openreport,,, where NUMERIC FIELD= NUMERIC FIELD and TEXT FIELD= TEXT FIELD

3) Docmd.openreport,,, where NUMERIC FIELD= TEXT FIELD and TEXT FIELD= TEXT FIELD

I know it's annoying but I need your help as I'm so confused.
If there's a guiding reference for using multiple criteria, it'll be great

Thanks in advance

 

[pbaldy]

This has a multi-criteria example at the end:

General: DLookup Usage Samples

 

[Gasman]

Put the criteria into a string variable and debug.print it to see what you have.

 

[Capitala]

Thanks for all of you

 

[pbaldy]

No problem, I assume you got it working?