change format in make table query

[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?

 

[Noëlla Gabriël]

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.

 

[John W. Vinson]

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?

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.