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
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