query based on query with user selected dates

  • Thread starter Thread starter g hoffman
  • Start date Start date
G

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
 
While in design view of either query select Query->Parameters and enter
[enter the beg date] Date/Time
[enter the end date] Date/Time
 
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?
Click to expand...

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.
 
Back
Top