Split Currency Field

[RayMilhon]

I have a report that prints on a Government form. The form has the currency in 2 specific positions for dollars and cents. I have the query the report is based on to get the dollar portion but not sure how to get the cents portion anybody have an idea?

[rpeare]

there are a few ways you can retrieve the cents portion of a currency value
maybe something like:

right(cstr(CurrencyValue), len(cstr(CurrencyValue)) - instr(cstr(CurrencyValue), "."))

depending on how your currency value is stored it might be as easy as

right(cstr(currencyvalue), 2)

you can also do it strictly with number values with something like

(CurrencyValue - int(CurrencyValue)) * 100

[RayMilhon]

Thanks Rpeare that was what I needed.