Counting Records in Report

[Steve@trop]

Access reports are rather new to me. I know what I want should be quite simple. I will soon be working on several other reports. If anyone has a link to a good tutorial it would be appreciated!

I've been struggling with getting a report to simply count records (I don't need any detail other than the counts). Here is what I have:

Table CompressorRoundsT contains these fields (many more actually but these are the ones I care about for this purpose):

Date, Shift, Round

Possible records in the shift field are 1st, 2nd, 3rd and the round field has Rnd 1 and Rnd 2.

For each date, I need to count the number of records per shift and per round. For example, the report should show that on June 7th, 1st shift has 14 records for round 1 and 14 records for round 2. Same for 2nd and 3rd shift. I don't need any other details of what the records contain, just the counts.

I've had some success but the layout ends up too spread out because it is including the individual records instead of just showing the counts and it isn't grouping the way I want.

Any pointers on this would be appreciated! If you need more details of the problem, just let me know. It's a report to help management see how many readings (rounds) were missed in a period of time.

Thanks,

Steve

 

[rzw0wr]

try Dcount() method.
expression.DCount(Expr, Domain, Criteria)

=DCount("[OrderID]", "Orders", "[ShipRegion] = 'CA'")

Dale

 

[Steve@trop]

I figured out that a query in Pivot Table view gives me what I want. I just have to get used to how to work the Pivot table in Access. It's different than Excel!