Prev: Web based news browser
Next: how do i perform a Count(Distinct) query for 2 different column va
From: Gene on 18 Nov 2009 14:01
I created a query and now I want to print out the query criteria. How do I
do this?
From: Ken Snell on 18 Nov 2009 14:37
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" <Gene(a)discussions.microsoft.com> wrote in message
news:D01DD85C-4250-4491-AAED-E6CAFF7E844C(a)microsoft.com...
>I created a query and now I want to print out the query criteria. How do I
> do this?


From: Duane Hookom on 18 Nov 2009 14:56
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?
From: KARL DEWEY on 19 Nov 2009 17:06
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?
 | 
Pages: 1
Prev: Web based news browser
Next: how do i perform a Count(Distinct) query for 2 different column va