Bookbinder75
Technical User
I have a cross tab query that has the date as a row heading. What I need to do is put a date pparameter on the cross tab. Any help would be appreciated. Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CROSS TAB QUERY
- Thread starter Bookbinder75
- Start date
- Status
If you mean you don't know how to enter a date parameter, create a new query in the QBE grid and enter a date in the selection criteria, in this type of format:
> #01/01/2000#
or something similar (see comparison operators for between etc.)
change to SQL view and see how this is formatted in th SQL statement. Cut and paste it into your crosstb query SQL. If you are trying to make an interactive paramenter, it's easier to put it in the underlying query, and base the crosstab on that query.
> #01/01/2000#
or something similar (see comparison operators for between etc.)
change to SQL view and see how this is formatted in th SQL statement. Cut and paste it into your crosstb query SQL. If you are trying to make an interactive paramenter, it's easier to put it in the underlying query, and base the crosstab on that query.
- Status
Similar threads
- Locked
- Question
- Locked
- Question