Posted by Skybuck Flying on 01/06/08 09:55

Following SQL example works:

(Birthday <> null) AND
(Birthday > #06/06/1978#) AND
(Birthday < #06/06/1979#)

Bye,
Skybuck.

• Next in forum: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?
• Prev in forum: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?
• Thread view: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

[Reply to this message]