By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Using wildcards in Crosstab Queries

P: n/a
Access 2002

I have a crosstab that is based on another query that references
criteria from combo boxes on a form. I have defined the parameters in
the crosstab and it works fine unless I use the "All" selection in the
combo. ("All" is added to the combo using a union statement with a
value of "*") I get a datatype mismatch error when using the "*". If
I leave the combo blank, then the crosstab works. But I use these same
combo's as criteria for other queries that require the "*" at times.

Any and all suggestion are truly appreciated!


Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.