Data Type

[ahajee]

I created a field in my query which populates each record with a date that i specify.

example: Hist Date: [Date]

When you run the query, it asks for a paramenter value or date. The output is created in a make table and the data type is binary. Is there a way to change it from Binary to Date in the query itself? If you change the data type in the table, it reverts back to binary once the query is run.

Thanks.

 

[Andrew Fergus]

Hi, the answer proposed by Norie in this thread might also help you.
Andrew.