[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Access 2003 Report Help

Posted on 2012-08-23
Medium Priority
Last Modified: 2012-08-23
I have been getting great help on ee and hoping to get a little more. Sorry ahead of time if this gets long winded. I have a db that is very simple. It contains one form and one table. There are three critical fields. Two are drop downs and the other is date. The first drop down is called  Area  (CVT, FWW33, Machining) the second drop down is called status and contains (Audits Completed, Safe Audits, and Unsafe Audits). What I need to happen is on a report count the number of "status" within the appropriate area. I got help getting this to work until I introduced dates. So let's say I have multiple records. Right now this is the result I get:

CVT                  Audits Completed    8/3/12
CVT                  Audits Completed    8/14/12
CVT                  Audits Completed    8/16/12
CVT                  Unsafe Audits           8/1/12

FWV33             Audits Completed    8/3/12  

And so on. What I am looking for is something like this

CVT                  Audits Completed    8/3/12
CVT                  Audits Completed    8/14/12
CVT                  Audits Completed    8/16/12
CVT                  Unsafe Audits           8/1/12
Audits Completed 3
Unsafe Audits        1

Audits Completed    8/3/12  
Audits Completed 1

And so On.

Attached is a copy of my db in the hopes someone can fill in the blanks. In my db Report2 gives me the counts correctly minus the date. Qry_2 report is where I am trying to add dates to get the result above. Please feel free to play around with either as I am stumped. My overall goal is to then be able to query on a date range and have the output above.
Question by:tmaususer
  • 2
LVL 74

Accepted Solution

Jeffrey Coachman earned 1200 total points
ID: 38325802
Your Report really should be a "Grouped" report, then this is easy.

Just like I showed you before:
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38326562
Glad I could help again.

I hope you are now studying up on "Aggregate" functions...
(DCount, DSum, DLookup, DMin, DMax, ...etc)


Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

834 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