different formats in query & table

A

ACG

I set up a query and formatted number columns with fixed format. Query runs
fine & shows correct formats. When I use the query in a table to lookup data
the data is returned properly but the number formats are not correct. I've
checked the underlying table(s) the query is using and the formats there are
correct.

Thanks
 
D

Duane Hookom

All data should be displayed to your users through forms and reports. You can
set the format properties of the controls displaying the values.
 

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

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Stored date is not being recognised 1
Adding Sequential Numbers to a Query 1
change a text format to number format 6
Format a table field 2
Number Format in Chart Datasheet 1
writing query data back into the table? 6
Keeping number format when merging into Microsoft Word 2

Top