• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

Access 2003 Report Help

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


FWV33            
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.
Safety-new-2.mdb
0
tmaususer
Asked:
tmaususer
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Your Report really should be a "Grouped" report, then this is easy.

Just like I showed you before:
Safety-new-2.mdb
0
 
Jeffrey CoachmanMIS LiasonCommented:
Great,
Glad I could help again.
;-)

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

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now