Make Table Specify Data type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When making a table with a Make Table Query, how can I specify a Data Type?

I am making calculations with a date. In a plain query it displays as a
date. But, when using the query to make a table, it defines the data type as
text instead of date. Then I end up with a data mismatch when trying to use
the newly made table with another query.
 
Create the table exactly as you want it, and use an Append query to populate
it.

A less desirable approach would be to typecast the date in your Make Table
query, e.g.:
CVDate([MyDate]) AS MyNewDate
More on that approach in this article:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 
Thank you, will use an Append query. I just already have so many Make Table
and Append queries to get to this one report that I was trying to skip it.
Thx again for taking the time to respond to my questions.



Allen Browne said:
Create the table exactly as you want it, and use an Append query to populate
it.

A less desirable approach would be to typecast the date in your Make Table
query, e.g.:
CVDate([MyDate]) AS MyNewDate
More on that approach in this article:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

neenmarie said:
When making a table with a Make Table Query, how can I specify a Data
Type?

I am making calculations with a date. In a plain query it displays as a
date. But, when using the query to make a table, it defines the data type
as
text instead of date. Then I end up with a data mismatch when trying to
use
the newly made table with another query.
Click to expand...
Click to expand...
 
Back
Top