Currency fields in reports

G

Guest

I have a problem with currency fields on an Access
report. I have been printing invoices with VAT (sales
tax) added at 17.5% I have been performing the
calculation in the invoice query and use CCur
(Fee/100*17.5). This gives me a result and rounds up the
field. I now need to produce a summary report which
produces a sub total of the VAT (sales tax).
Unfortunately the currency data type is to 4 decimal
places so when I perform the sub-total I get problems.
For example the amount 12.1250 is formatted in the report
query (CCur fiunction) as £12.13. This appears on the
report (and the invoice). However when I add two amounts
together 12.1250 and 12.1250 the result is 24.2500 and the
sub total is formatted as £24.25. Now the report really
needs to show the addition of the formatted fields £12.13
and £12.13 giving £24.26. I have tried to use the Round
function in the query but this rounds down, so 12.125
becomes 12.12- not what the invoice printed so I cant use
it. Can I solve this without resorting to writing my own
rounding sub-routine?
 

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