how do I print out query criteria

K

Ken Snell

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

KARL DEWEY

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top