query based on query with user selected dates

[g hoffman]

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

 

[Duane Hookom]

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

 

[John Vinson]

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?

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.