Developer Forum

I have a crosstab query that is pulling from a query that
uses date between [enter the beg date] and [enter the end
date]. works fine with the first query, but when I try to
run the crosstab, it says the jet does not recognize those
fields.
What is the best way to do this, since what I am doing is
not working?

G Hoffman

While in design view of either query select Query->Parameters and enter
[enter the beg date] Date/Time
[enter the end date] Date/Time

--
Duane Hookom
MS Access MVP

On Tue, 6 Jul 2004 21:10:48 -0700, "g hoffman"



With any query, you *may* pre-define the query's Parameters. With a
crosstab query you *must* do so!

Open the query in design view; right mouseclick the background of the
tables, and select Parameters from the dropdown menu. Put

[Enter the beg date]

in the left hand column, and specify that it is of date/time type in
the right; do the same for the other parameter. I'd copy and paste
them from the criteria line - they must match exactly.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://www.yqcomputer.com/