Query problem (1 Viewer)

[artificiality]

The following query does not work since it does not accept "AS date". Why ?

It accepts AS RunID :


SELECT 257 AS RunID, RawData.fullName, RawData.name, RawData.category, RawData.type, RawData.subType, RawData.numberOfLines, RawData.dataType, RawData.virtual, #1/3/2007# AS date, RawData.namespace
FROM RawData
WHERE (((RawData.namespace)='customer.demo') AND ((RawData.RunID)=256));

 

[KeithG]

Date is a reserved word in Access because it is the name of a function.

 

[artificiality]

I need date , not Date.

Access does not support case sensitivity ?

 

[boblarson]

you can't use key words regardless of case in Access