Cretaing Date Field in Query

[Flopper]

Greetings,

Access 2000.

I'm trying to create a query which displays an additional column of a date type. I've tried

Expr1: Date(2005,05,01)

but i receive an error message stating that there is not enough arguments. This works in Excel but in Access... why?

I've checked the Access help and it appears that this method is correct.

Can anyone help?

Cheers

 

[PHV]

Expr1: DateSerial(2005,05,01)

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