Using Make Table to Enter as Date/Time and Not Binary

[Jerseynjphillypa]

So I created the following field



DateIntoSystem: [DateIntoSystem]

But when I click on "Make Table", I prompt box comes up and I enter 06/20/2012 as the Date

But the table that gets created, the Data Type in the Table is Binary. I want it to be Date/Time.

I also changed the format in the Property Sheet to Short Date.

[JoeM]

I have had some issues at times with Make Table queries using data types other than what I intended. One way to get around that is to set-up the shell of the table first (when you can designate the data type/format of each field), and use an Append Query instead to write the data to the pre-existing table template.

If this is a process you have to re-use/repeat, just use a Delete Query or (SQL code in VBA) in order to clear out the table first.

[Jerseynjphillypa]

thanks for your help