My trailing zeroes are being truncated

W

Walt Hoffman

we're viewing currency data in a table/query - when you
open the query itself the two #s following the decimal
are there, but when we attempt to use that data in a
document the trailing zeros disappear, e.g $21.90 becomes
$21.9.

Your assistance will be greatly appreciated
 
D

Duane Hookom

I believe you can set the format within Word. An alternative is to use
NumFormatted:Format([YourField],"$0.00")
or something similar that would force a text string.
 

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