Solved

Summarizing data in Microsoft Access

Posted on 2014-10-15
2
202 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
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 47

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

930 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now