Report based on Crosstab Query

D

Dlowry61

Hi, I'm trying to get a report out based on a crosstab query. The quer
is built and works fine. It has 3 parameters. The issue is the report
If the report is run based on the unrestricted crosstab query - n
problem. Once the parameters are prompted for and accepted the repor
errors out - "Microsoft Jet database engine does not recongize '' as
valid field name or expresion." Again the query, when run has n
issue. Can anyone give me a point in the right direction?

Thanks - Da
 
D

Duane Hookom

Could you possibly share the SQL view of your crosstab? Did you set the data
types of your parameters? Did you set the column headings property? Are you
doing anything to handle varying column headings?
 
Top