In SAS I am able to use a Proc Summary and it gives me exactly what I want. Is there a way in Access to get the same results.
My SAS statement looks like this.
Proc Summary Data=CLAIMS_TOT;
Var BILLED ADJUD CLAIM_CT;
BY MAINT FFSORCAPIND LICENSE PROV_NAME;
Output Out=Total_APR_2013 Sum=;
It gives me totals for Billed ADJUD and CLAIM_CT by prov_name within license within ffsocapind within Maint(DATE)