Adding a Date data-type field with a Make-Table query

  • Thread starter Thread starter bigomega73
  • Start date Start date
B

bigomega73

I am using a make-table query to make a table. Some of the fields are being
populated with this query, however I need to add several more fields with
null values so that they can be updated by subsequent update queries. The
default field-type that is created if I just put in a field name is Text. How
can I create a Date field-type field from a make-table query which has a null
value?
 
Well, you can create a DateTime field by using something like:
DateField: CDate(0)
But the field won't be empty, it will contain 0, or, stated as a date value,
Dec 30, 1899 12:00 am.

I don't know of any way to force the creation of a DateTime field in a
MakeTable query without providing a Numeric value.

Workaround: since you say you have subsequent Update queries that you run
against this table:
1) use the above in your MakeTable
2) run an additional Update query right after table creation that
changes DateField from 0 to Null
 
Instead of a Maketable query, Create the Table how you want it (Here
you set the date field).
Then change the MakeTable query to an Append Query. Make sure you run
a Delete Query to delete all the rows before you use the Append Query.

- GL
 
Thanks for the suggestion George. That is actually how I ended up working
around it. I don't like to add too many unnecessary queries to my database,
but I guess in this case there was no way around it.
 
Back
Top