hey guys,
Hope someone is able to give me a hand with this query, I get close to what I need but not quite there....
Basically what I'm trying to do is get a query to return results when the count of a certain field's value is greater than 1 & it is between 2 dates (the current date and 7 days prior to the current date).
Ideally I'd only want to show the results for anything after the first counted record between those dates, but if that's not possible that's totally fine I can work with that
...
I've attached a sample DB which hopefully give you a better idea what I'm trying to do, because I'm generally horrible at trying to explain it via text :banghead:
Thanks heaps all!!
Hope someone is able to give me a hand with this query, I get close to what I need but not quite there....
Basically what I'm trying to do is get a query to return results when the count of a certain field's value is greater than 1 & it is between 2 dates (the current date and 7 days prior to the current date).
Ideally I'd only want to show the results for anything after the first counted record between those dates, but if that's not possible that's totally fine I can work with that

I've attached a sample DB which hopefully give you a better idea what I'm trying to do, because I'm generally horrible at trying to explain it via text :banghead:
Thanks heaps all!!