Access 2003 Report Help

Posted on 2012-08-23
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
    LVL 74

    Accepted Solution

    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
    Glad I could help again.

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


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    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.

    732 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