Createefield code help

[Guest]

I want to use VBA code to create a field (OdEnd) as double with one decimal
place in table Stats. I cannot figure out the entire syntax. Can someone help
me?

 

[Marshall Barton]

I want to use VBA code to create a field (OdEnd) as double with one decimal
place in table Stats. I cannot figure out the entire syntax.

Here's one way:

CurrentDb.Execute "ALTER TABLE Stats " _
& "ADD COLUMN OdEnd DOUBLE"

The number of decimal places is not an inherant attribute of
a table field, it's a display/formatting thing that should
be dealt with in a form/report text box.