Convert query result to Number from Date?

[djayam]

Hi All,

I have a query (Query1) that returns (amongst other things) the day of the week of a particular date ([Query1.DayNumber]):

=Format([Shipdate],"w")

I want to join this query to my Weekday table on [Weekdays.DayNumber] = [Query1.DayNumber] but it seems the result of Query1 is not a number as I get a type mismatch error. How do I convert this in access (again, easy is SQL but...)

Thanks,

Jason

 

[PHV]

=Int(Format([Shipdate],"w"))

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

 

[djayam]

The F1 help in Access is crap. I tried so many questions to get this answer!!

Thanks again PHV.