Hi,
In your make table query, try using the following for the field you'd like to
have as currency....
Format([your field],"Currency")
where [your field] is the calculation or the field directly.
Hope this helps,
Jose
Brad <[EMAIL PROTECTED]> wrote:
Hi All, I have a question. I created a make table query and when I
pull
in dollar amounts, it doesn't use the format I requested (I.E. $200.59
shows as $200.5869). I right click on the column in the design view and
select currency and auto or 2 decimal places and still it comes out
wrong. Am I missing something? Also, I am summarizing the fields.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
