D
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
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