Count data in a field (1 Viewer)

N

nancy54

Registered User.

Local time

Yesterday, 19:46

Joined

Jun 19, 2018

Messages

49

• Dec 26, 2018

• #1

Hello,
I have a table that list each batch that was produced with a ProductNumber field. I want to create a qry or report that counts the number of times each ProductNumber was entered. I need to know what batches are made more frequently.

Thanks, Nancy

 

June7

AWF VIP

Local time

Yesterday, 15:46

Joined

Mar 9, 2014

Messages

5,465

• Dec 26, 2018

• #2

Sounds like need to do an aggregate (GROUP BY) query or a report and use its Sorting & Grouping features with aggregate calcs in textboxes. Provide sample data.

 

isladogs

MVP / VIP

Local time

Today, 00:46

Joined

Jan 14, 2017

Messages

18,209

• Dec 26, 2018

• #3

As already stated, create an aggregate query by clicking the totals button on the ribbon.
Add your table then add the ProductNumber field to the query design window twice.
The totals row will say Group By. Change one of those to Count and run the query.

 

N

nancy54

Registered User.

Local time

Yesterday, 19:46

Joined

Jun 19, 2018

Messages

49

• Dec 27, 2018

• #4

Isladogs,
Thanks you for the explicate instructions. This worked perfectly!
Nancy