Report Field Name problem

[dogman_2000]

I have a crosstab query which I am using as my recordsource for a
report I have.
Because sometimes I have more or less columns in my query I get the
following problem when I run my report:

The Microsoft Jet database engine does not recognise [FieldName] as a
valid field name or expression.

I understand this problem but can anyone tell me if it's possible to
trap this error and ignore it so that the report\query still runs? I
realise that the field will have errors in it but this doesn't worry
me.

Any help\alternative suggestion would be greatly appreciated.

Andrew

 

[Duane Hookom]

Depending on your crosstab, you can:
1) enter all possible column headings in the Column Headings property
2) if the column headings are date/time intervals there are alternatives
3) use dynamically generated values like the Crosstab demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane