0

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.

Cheers

1
Contributor
1
Reply
2
Views
8 Years
Discussion Span
Last Post by munror
0

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!

Cheers

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.