Brad forget what the table shows, it's irrelevant. The table is not a spreadsheet and you should *never* be opening it to look at data.
You display your data on a form or in a report. Those are based on a Query and not a Table and in the form and the Report you can format and display your data any way you want. Brett Brad 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. > > -- Brett Collings Strengthening Families Administrator D2D 46422 DDI (04) 916 3422 ------------------------------- This email message and any attachment(s) is intended only for the person(s) or entity(entities) to whom it is addressed. The information it contains may be classified as IN CONFIDENCE and may be legally privileged. If you are not the intended recipient any use, disclosure or copying of the message or attachment(s) is strictly prohibited. If you have received this message in error please notify us immediately and destroy it and any attachment(s). Thank you. The Ministry of Social Development accepts no responsibility for changes made to this message or to any attachment(s) after transmission from the Ministry. ------------------------------- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> 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/
