Jet DB Error

F

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?
 
J

Jeff L

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

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

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?
 
F

Flintstone

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

Works fine now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top