Make-Table Query Number Double Format

[Cosmos75]

I have a Make-Table query that pulls info from a table, makes a new table with the info and adds a column with a default value of 0.

The expression that I use for the added column is Usage: 0

The problem is the new table generated by the Make-table query formats my new column Usage as a LONG INTEGER number and I want it to be formated as a DOUBLE number.

How do I do this??

 

[Pat Hartman]

Try:

Usage: Dbl(0.0)

 

[Cosmos75]

Pat,

Dbl(0.0) didn't work.

Thank you for trying!

 

[Jon K]

Usage: Cdbl(0)

 

[Cosmos75]

JonK,

Thanks! That worked!

Just curious, are there any other formatting functions like that? For Decimals, Fixed or Standard??? Is there a resource to find such things online?

 

[Jon K]

See Access's help for these functions:

CByte()
CCur()
CDbl()
CDec()
CInt()
CLng()
CSng()