Data Type Change

[brahmabull525]

I am building a Make Table query in Access. I am using the following as criteria "Between [enter start date] and [enter end date]" on a date field. When the table is made, two new fields are created called "StartDate" and "EndDate". These come from columns set-up in the query as "StartDate:[enter start date]" and "EndDate:[enter end date]".

When the "StartDate" and "EndDate" fields are created in the new table, the data shows up, by the Data Type is set to Binary. Is there a way to have the query automatically set the Data Type as Date/Time instead?

Any help would be most appreciated. Thanks!

 

[PHV]

In the SQL view of the query you may add this instruction (as first line):
PARAMETERS [enter start date] DateTime, [enter end date] DateTime;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[brahmabull525]

PH, you're a life saver. That's exactly what I needed.

Thanks!!!!