Solved

Summarizing data in Microsoft Access

Posted on 2014-10-15
2
211 Views
Last Modified: 2014-10-15
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)
0
Comment
Question by:morinia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 57
ID: 40382674
In Access, that would be accomplished with a SQL Statement either by:

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.
0
 
LVL 48

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 40382691
So the SQL query might look like:

SELECT Maint, FFSORDAPIND, LICENSE, Prov_Name, Sum(Billed) as SumOfBilled,
    SUM(AJDUD) as SumOfAdjud, SUM(CLAIM_CT) as SumOfClaimCt
FROM YourTableName
GROUP BY MAINT, FFSORCAPIND, LICENSE, PROV_NAME;
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question