I can do, but it is a very general question that can apply to any single date field on any database. Didn't want to over-complicate it but here goes...

CREATE TABLE...

COldCoffee (4/13/2010)

---

Hmmm.. cool.. but before u could post question, i hope that u had looked over that link i specified in my earlier post on how to post question to...

COldCoffee (4/13/2010)

---

Hmmm.. cool.. but before u could post question, i hope that u had looked over that link i specified in my earlier post on how to post question to...

Thanks all, yeah Kingston's code has done it for me.

Never knew you could do the filter as part of the join. That was something I never even considered! So that's...