Change format to results of Make table query

  • Thread starter Thread starter mcarter
  • Start date Start date
M

mcarter

I'm not using SQL code, but the graphical representation in ACCESS.
I made a tmake table query to make a table of average inquiry counts.
(format 0.xxxxx)
and when I looked at the table, all the values are 0 and the
field size is decimal with scale 0. I need the field to keep the formatting
from the make table query so the values remain 0.xxxxxx instead of 0's.
I know that you can alter with SQL, but how can I do it with the graphical
representation. I tried to set the properties in the field before I make
the table,
but all the values are "rounded" to nearest whole number. so instead of
getting actual average values, I get a table full of 0's instead.
thanks
 
I would not set any format in the make table query. I might use an expression
like CDbl([Your Field]) to force a field that allows storing decimal values.
 
mcarter said:
I'm not using SQL code, but the graphical representation in ACCESS.
Click to expand...

The graphical query builder is JUST A TOOL to construct SQL. You are in fact
using SQL, since all queries however constructed are in SQL.
I made a tmake table query to make a table of average inquiry counts.
(format 0.xxxxx)
Click to expand...

Why?

The records in the table *will be wrong* the moment any new record is added
to your table; and a maketable query is a timeconsuming and database
bloating construct. You can base a Report, or a Form, or an export on your
totals query which does the counts. What benefit do you accrue from creating
a new redundant table of derived data?
 
Back
Top