Jet DB Error

[Flintstone]

I have a Report that uses a crosstab query as its data source. There
are a number of fields and it works fine if there is data that will
populate all of the columns.

The problem is that when a column is empty I receive the following
error:
The Microsoft Jet Database Engine does not recognise 'HP' as a valid
field name or expression.

So 'HP' was the empty column name.

This column is referenced from the details section using =Nz([HP];0) as
the control source.

Is there a workaround for this problem because the columns will not
always contain any data?

 

[Jeff L]

=iif(IsNull([HP]), True Condition, False Condition)

So you could put =iif(IsNull([HP]), [HP], 0)

 

[Flintstone]

Yes, unfortunately it still gives errors. I have discovered that if I
go to my crosstab query->design view->properties and type the column
names (electricity,phone,etc) in under the Column Headings phoperty I
can run the report.

The problem now is that I am prompted for a value for each column that
has no value. I can click OK 8 times and the report proceeds okay but I
would prefer not to need to do this.

Any ideas?

 

[Flintstone]

I had missed some columns ... they are only used in the calculations.

Works fine now.