Hi
I have a query and I am trying to subtotal by "Provider" for each sales associate. Then take the %to total of the provider by name for each associate.
I can do it in Excel using a Pivot Table very easily but I would like to do it in Access saving me some steps.
Any help would be much appreciated.
Thanks
Elaine