datepart in sql string

[Dannasoft]

Hi!



I'm trying to create an sql string that will return all records from a table where the hour in a datetime field is between 7PM and 7AM.

Here's the where clause I thought would work.

Between DatePart("h",#11:59:00 PM#) And DatePart("h",#7:00:00 AM#) Or Between DatePart("h",#7:00:00 PM#) And DatePart("h",#11:59:00 PM#)

Yet no records are returned. Any ideas?

[NTC]

rather than 'between' try using math compares: >=

am trusting that you've researched DatePart syntax in VBA help and that is correct......

also with any code - temporarily strip it down to 1 compare only and check results before adding more AND / OR