Member Avatar for munror

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
  • 255 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by munror
Member Avatar for munror

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.