Hi there,

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.


Sorry, Please forget it, it isn't an issue any more.

For some reason when I put entries into the database manually they never registered in the database in that same way that they were recorded through the form on the site!

I just entered a referral on the 26th and it showed up!

Apologies again!