S
susanmgarrett
Goal: I am trying to create a standard field in a query, in which I
can use an IsNull statement to fill the field with the Euro content if
the dollar content field is empty.
I have an Access query that feeds into a Word document mailmerge. In
this document, there is a field that may be in dollars or euros (one
or the other).
In the Access table, there is a payment field for dollars
(perpagerate) and a separate payment field for euros(perpageratee) - I
have to have these two fields as separate entities because of
accounting purposes. I am trying to create a standard field (payrate)
in the query, in which I can use a IsNull statement to fill the field
with the Euro content if the dollar content field is empty.
payrate: IIf(IsNull([Contracts]![perpagerate]),[Contracts]![perpageratee],[Contracts]![perpagerate])
This actually places the number content in the payrate field quite
satisfactorally, but the Euros show up as dollars instead of Euros.
I have tried some on-the-fly formatting inside that IsNull statement
and nothing seems to work.
If it helps, this is a US machine with a US base setting of dollars.
Does anyone have any idea of how this may be possible?
BTW - there's no monetary calculation on the Word end, so it WOULD be
possible for me to simply place BOTH fields in the document, side by
side, with an IsNull statement that will not print the null record.
Thanks!
Susan M. Garrett
can use an IsNull statement to fill the field with the Euro content if
the dollar content field is empty.
I have an Access query that feeds into a Word document mailmerge. In
this document, there is a field that may be in dollars or euros (one
or the other).
In the Access table, there is a payment field for dollars
(perpagerate) and a separate payment field for euros(perpageratee) - I
have to have these two fields as separate entities because of
accounting purposes. I am trying to create a standard field (payrate)
in the query, in which I can use a IsNull statement to fill the field
with the Euro content if the dollar content field is empty.
payrate: IIf(IsNull([Contracts]![perpagerate]),[Contracts]![perpageratee],[Contracts]![perpagerate])
This actually places the number content in the payrate field quite
satisfactorally, but the Euros show up as dollars instead of Euros.
I have tried some on-the-fly formatting inside that IsNull statement
and nothing seems to work.
If it helps, this is a US machine with a US base setting of dollars.
Does anyone have any idea of how this may be possible?
BTW - there's no monetary calculation on the Word end, so it WOULD be
possible for me to simply place BOTH fields in the document, side by
side, with an IsNull statement that will not print the null record.
Thanks!
Susan M. Garrett