Error message on Cross_tab report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top