DataTypes with a make table query

[SpiderFlight]

Do any of you Access grus know the answer to this?

After running the query below (Make Table) the field Entry_date has a data type of Number. How can I force the data type to be Date/Time?

Any assistance is greatly welcome.



SELECT DISTINCTROW MonthlyAuditSubQry1.dsu, Format$([MonthlyAuditSubQry1].[Entry_date],"mm/dd/yyyy") AS Entry_date, Sum(MonthlyAuditSubQry1.error_cnt) AS SumOferror_cnt, Sum(MonthlyAuditSubQry1.Total_audit) AS Total_audits INTO BusOps_MonthlyAudit_xls
FROM MonthlyAuditSubQry1
GROUP BY MonthlyAuditSubQry1.dsu, Format$([MonthlyAuditSubQry1].[Entry_date],"mm/dd/yyyy")
ORDER BY Format$([MonthlyAuditSubQry1].[Entry_date],"mm/dd/yyyy");

 

[ssatech]

If the data from your field "Entry_date" is based on a table. Can you not just format this field in that table to something like: Format: Short Date and the Input Mask: 99/99/00.

 

[PHV]

And what about this ?
SELECT dsu, CDate([Entry_date]) AS Entry_date, Sum(error_cnt) AS SumOferror_cnt, Sum(Total_audit) AS Total_audits
INTO BusOps_MonthlyAudit_xls
FROM MonthlyAuditSubQry1
GROUP BY dsu, Entry_date
ORDER BY 2

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