Date() function returns text

[Brett]

I have the following make table query; however it is putting the
results in Text format. How do I correct this to put the results as
Number format?

SELECT Format(Date(),"dd") AS [Day], Format(Date(),"m") AS [Month],
Format(Date(),"yyyy") AS [Year] INTO DateToday;

Thanks.

 

[Roger Carlson]

The format function converts numbers to text. Try this:

SELECT Day(Date()) AS [Day], Month(Date()) AS [Month], Year(Date()) AS
[Year] INTO DateToday;

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Brett]

Thank you Roger! That solved a major problem with my report.

 

[KARL DEWEY]

Simpler yet ---
SELECT Date() INTO DateToday;