A clue to why they behave that way is if you enter the Column Headings
property, you won't need to declare your data parameter types. For instance
if you have a date criteria but set your column headings property like:
Column Headings: "Jan","Feb","Mar","Apr"
You don't need to specify the data types of your parameters.
--
Duane Hookom
MS Access MVP
--
"Anonymous" wrote in message
news
p.s55wfqj1aq8s7f@kvitjb...
I wonder why Crosstab queries behave that way...I was stuck with a
crosstab a few weeks ago until I figured that out on my own...
Jeff
On Wed, 08 Mar 2006 13:14:39 -0500, Duane Hookom
wrote:
This question gets asked and answered several times per week. You can use
parameters/criteria in crosstab queries if you explicitly identify the
data
types of the criteria. Select Query-Parameters and enter
Forms!frmA!txtB Date/Time
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/