Formatting number fields in Make Table query

G

Guest

I've used CDec and FormatNumber in a Make Table query to create Number fields
with 2 decimal places. However, my tables are always created with a Double
Field Size. HOw can I change this?
 
J

JohnFol

The format relates to how they are displayed. The "Double" relates to how it
is stored. They are 2 different things.

when you come to use the new table in your form / report, you can apply the
2dp there.
 
G

Guest

Got it. Thanks!

JohnFol said:
The format relates to how they are displayed. The "Double" relates to how it
is stored. They are 2 different things.

when you come to use the new table in your form / report, you can apply the
2dp there.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
return data right justified 2
Help with formatting a query 1
Make table query: [Enter 1] AS Test 1
Formatting a Number in a Query Field 2
Decimal places in calculated fields 6
Make Table Query 1
Format query result as Data Type Number, Field Size Decimal 3

Top