Can you use parameters with Cross tab queries

[Pack10]

I would like to use a parameter in a cross tab query (from a form) to enter a date...getting error 2950
Can this be done in a cross tab.

Thanks

 

[lameid]

Should be fine... post your SQL and/or ensure you specify the datatype of the parameter unless it is text.

 

[dhookom]

You can either set the data type in the Query Parameters dialog or set the Column Headings property.

Duane
Hook'D on Access
MS Access MVP