Just joined the community!
Been having trouble all day with the following select statement and MS Access database:
[SELECT * FROM client_referrals WHERE client_id = 1 AND ((date_of_referral >= #9/21/2008#) AND (date_of_referral < #9/28/2008#)) ORDER BY referral_lastname ASC]
The [((date_of_referral >= #9/21/2008#)] section of works, so all dates after or equal to the 21st of Sept work, however no entries after the 9/25/2008 are showing up, I know for a fact that there is one entry on the 26th and one on the 30th, which I put in for testing purposes.
Any help would really be appreciated.