Keep field TYPE with Create Table Query

  • Thread starter Thread starter Meilu
  • Start date Start date
M

Meilu

Hello,

I posted this question before ... but I forgot where the
posting was...

Anyway ...
I'm trying to use a Create Table query to copy Table A
into a temporary table... mainly for the purpose of data
manipulation. The problem is that when I copy Table A
into TempTable, the [Date] field becomes a text field.
That's sort of a problem because I am using the [Date]
field for comparison purposes.

Any idea on how to fix this?
Thanks,
Meilu
 
Dear Meilu:

If you create the TempTable with the datatypes you want, and then
append the rows from TableA to that, you can control this completely.

When you use a shortcut method like MakeTable you lose the ability to
control certain things. It's usually better to keep control rather
than to make it too easy. There's a trade off in there!

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top