Subject | Selecting invoices between specific dates? |
---|---|
Author | Robin Davis |
Post date | 2006-12-09T19:38:12Z |
Hi,
I'm obviously missing something here.
We have a table of invoices and we want to send Christmas cards to any
NEW clients in 2006. I am trying to select by invoicedate, which is
straight forward, but how in hell do I select people from that list who
we have billed in 2006 but NOT in previous years?
Sorry, my brain has gone to mush!
Rob Davis
I'm obviously missing something here.
We have a table of invoices and we want to send Christmas cards to any
NEW clients in 2006. I am trying to select by invoicedate, which is
straight forward, but how in hell do I select people from that list who
we have billed in 2006 but NOT in previous years?
Sorry, my brain has gone to mush!
Rob Davis