how do I print out query criteria

  • Thread starter Thread starter Gene
  • Start date Start date
Open the query in design view. Then click on Query View button on Toolbar,
and change to SQL View. The SQL statement for your query is displayed there,
and you can copy it.
 
If you mean as an output of the query then open in design view, copy criteria
and paste and edit in a blank field row space like this --
My_Criteria: "Between #10/1/2009# And #11/31/2009#"
or
My_Criteria: "Between " & [Enter start] & "and " & [Enter end]
 
Back
Top