different formats in query & table

  • Thread starter Thread starter ACG
  • Start date Start date
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
 
All data should be displayed to your users through forms and reports. You can
set the format properties of the controls displaying the values.
 
Back
Top