Error message on Cross_tab report

[Frank Situmorang]

Hello:

I have designed a crosstab query and report after I learned from this forum.
I was succesful when I first designed it, but now the error message says" the
Morcrosoft Jet Database engine does not recoqnize 'Euro" as a valid field
name or expression'.

For Your information in my design there i a currencysymbol filed, and there
are 5 type of currency, Rp. USD, Yen and Euro SGD. Why the error message
occurred for Euro while the other 4 currency are not mentioned?

Please help. Thanks in advance for any idea provided.

Frank

 

[Allen Browne]

Chances are that for a particular report run (filtering perhaps?) there are
no Euros. Consequently the crosstab is not supplying that column, and so the
report can't find the field named Euro that appears on the report somewhere.

You can solve the problem by explicitly declaring all 5 currencies in the
Column Headings property of the query, so it supplies all 5 columns, even if
there are no Euros.

Details:
Crosstab query techniques - row totals, zeros, parameters, column
headings
at:
http://allenbrowne.com/ser-67.html#ColHead

 

[Frank Situmorang]

Yes, Allen, since I wanted to show the outstanding invoices only, so I have
the filtering of Invoice balance should not be zero. In my case now for the
Euro there is no more outstanding balance, so maybe that is the reason of
this error.

My problem now, I am not too clear on your explanation on how we can solve
the problem can you explain it again?.

Thank you very much.

Frank

 

[Allen Browne]

The steps are explained in the last section of this article:
http://allenbrowne.com/ser-67.html#ColHead