If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I print out query criteria
I created a query and now I want to print out the query criteria. How do I
do this? |
#2
|
|||
|
|||
how do I print out query criteria
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. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Gene" wrote in message news I created a query and now I want to print out the query criteria. How do I do this? |
#3
|
|||
|
|||
how do I print out query criteria
You can view the SQL, copy it to NotePad, and print it.
-- Duane Hookom Microsoft Access MVP "Gene" wrote: I created a query and now I want to print out the query criteria. How do I do this? |
#4
|
|||
|
|||
how do I print out query criteria
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] -- Build a little, test a little. "Gene" wrote: I created a query and now I want to print out the query criteria. How do I do this? |
Thread Tools | |
Display Modes | |
|
|