truncate date in Access SQL 1

[dmaytum]

Is there a way to truncate a date field in an Access SQL join statement. I'm joining a date field with a date-time and a field with just a date, but not returning anything since there are no matches. Is there a "trunc" function that can be used in the join statement, like there is in Oracle?

 

[PHV]

ON Int(Table1.DateTime)=Int(Table2.DateTime)

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