Number format changes when query converted from Select to Make table

  • Thread starter Thread starter Keith Kaminetzky
  • Start date Start date
K

Keith Kaminetzky

I have a query which calculates a percent using expression builder and it
works fine as a select query. If I change the query type to Make table or
append query the format or what I can see is inconsistent with the results
from the select query.

eg. Select query result 1.339%
Appearance in table 1

I've tried changing the table in design view but I am apparently missing
some issue? Any ideas thanks KK
 
In the table, is the field where you put this percent defined as Integer or
Long Integer?
If so, change it to Single or Double.

If it's already defined as Single or Double, check its Format property.

HTH
 
I have a query which calculates a percent using expression builder and it
works fine as a select query. If I change the query type to Make table or
append query the format or what I can see is inconsistent with the results
from the select query.

eg. Select query result 1.339%
Appearance in table 1

I've tried changing the table in design view but I am apparently missing
some issue? Any ideas thanks KK
Click to expand...

It would appear that you're storing the data in a default Number type,
which is Long Integer.

Create the table using a Single or Double datatype rather than Long
Integer, and try the append query into that.

Note that MakeTable queries are VERY rarely necessary. Storing a
calculated value is usually neither necessary nor appropriate, given
that you can base a Form, Report, or Export directly on the select
query.

John W. Vinson[MVP]
 
Back
Top