bypass query entry tp generate report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I based my report upon an existing query which used the NZ() function to
capture the users input from a form. However, in the case of this report I
just want it to generate the report with all records. Currently, I am
displayed a message box asking me for the form's input and if I leave it
blank and just press ok it load the report correctly. I would like to
automate this bypass or program the report to input a null.?!

Could someone shed some light on this for me,

Thank you as always,

Daniel
 
Daniel

Is the report based on a Parameter Query, whereby you are prompted for a
query criteria value? Or does the query reference a form control? If
the latter, is the form open whenever you try to run the report, and you
just want to print the report with no criteria?
 
Back
Top