morinia
asked on
Summarizing data in Microsoft Access
Experts,
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=;
Run;
It gives me totals for Billed ADJUD and CLAIM_CT by prov_name within license within ffsocapind within Maint(DATE)
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=;
Run;
It gives me totals for Billed ADJUD and CLAIM_CT by prov_name within license within ffsocapind within Maint(DATE)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. Writing a SQL statement directly.
2. Using a querydef (which is a saved SQL Statement along with some properties to control processing).
3. Using a Domain Funtion, such as DSUM() (you typically use this in places where SQL is not allowed, but an expression is - all the Domain Functions represent simple SQL Statements).
4. You write a custom VBA function to return the data you want and there are numerous ways that you might write that to actually grab the data..
Jim.