RCSully
New Member
- Joined
- Oct 13, 2009
- Messages
- 17
I have a table containing the fields State/City/Sales_Person/Item. I need to write a query total items sold. I need to count if he sold just ‘Widgets’ or ‘Gadgets’ or ‘Both’. My result would look like:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Bill:
State
City Total sold … 100
Widget-40
Gadget 40
Both 20
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Bill:
State
City Total sold … 100
Widget-40
Gadget 40
Both 20