change format in make table query

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

Thanks for any help.
I am trying to change the format of a make-table query to show just the
first two decimal places (xxxx.xx). I change the properties to fixed, and #
decimals to 2, but when I make the table, it doesn't change it. Any ideas?
 
Hi Ian,

there are 2 possible solutions:
1/ you really want only the rounded numbers to show; so you make in the make
table query a calculated field as fldRounded: round([fieldname];2) and
output that into the new table

2/ you want the complete number in the table but show it rounded to 2
decimals: just make the make-table query as it is, and then open the new
table and change the format property of the new field.
 
Thanks for any help.
I am trying to change the format of a make-table query to show just the
first two decimal places (xxxx.xx). I change the properties to fixed, and #
decimals to 2, but when I make the table, it doesn't change it. Any ideas?
Click to expand...

Don't confuse data STORAGE with data DISPLAY. They are separate tasks.

Make-table queries are very rarely necessary. If you're just creating this
table to print or display results, don't; use a Report or a Form respectively,
basing it on a select query.
 
Back
Top