I have a very quick job and need a QUICK turnaround.
What I need:
Status Date Count of Item1 Sum of Item 1 Count of Item 1 Sum of Item 2
These are all top level.
I am able to create separate crosstab queries for the 4 values I require, but am NOT able to pull them together into one query for the report I need to generate.
For someone who is well-versed in Access and SQL, it shouldn't take more than an hour maximum.