Assinging a data type to a query field

[rplant]

Hi

I have a query which pulls two fields from a table. The fields are:

Month
Year

In the table both of these fields are of data type "Number"

In the query I put them together by:
Date: [tblArchive].[Month] & " " & [tblArchive].[Year]

What I want to do is make the data type of the new "Date" field to be date/time so that I can use certain date/time functions. Is this possible? TIA

Rob

 

[BlackKnight]

Hi,

SELECT CDate([tblArchive].[Month] & " " & [tblArchive].[Year]) AS [Date]
FROM tblarchive
WHERE (((tblarchive.Month) Is Not Null) AND ((tblarchive.Year) Is Not Null));

Have a good one!
BK

 

[rplant]

That worked flawlessly. Thank you so much!!! You are a life saver! Thanks.