Comparing Events from one period to the next

[SteveQL]

Hi Everyone...
Hopefully you all can make me look like a genius yet again.

At a high level, here is what I need to do. THis data pertains to a retailer and I'm looking a Store and Item combinations where an item has not sold and counting the number of occurances. I am also doing the same for the previous month. What I need to get at next is a count of the occurances that occured in both months.

I am somewhat limited in that I am running this analysis from a POS application that my company sells and I need to figure a way to do this by unioning two queries or using some sort of comparison between domain functions to get at this. In short, no sub-queries.

Basically the fields look like this:

[Sales Rep] [Occurances this Period] [Occurances Last Period] [Common Occurances]

So far I am able to get this output with one query and I use a DSUM to get at the previous Moths occurances. I hope my details aren't too sketchy...

Cheers!
Steve

 

[PHV]

And what have you so far ?
BTW, why this ?
In short, no sub-queries

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886