Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-26-2018, 01:07 PM   #1
nancy54
Newly Registered User
 
Join Date: Jun 2018
Posts: 46
Thanks: 11
Thanked 0 Times in 0 Posts
nancy54 is on a distinguished road
Count data in a field

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

nancy54 is offline   Reply With Quote
Old 12-26-2018, 01:21 PM   #2
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,249
Thanks: 0
Thanked 304 Times in 304 Posts
June7 will become famous soon enough
Re: Count data in a field

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.
__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
June7 is offline   Reply With Quote
Old 12-26-2018, 03:45 PM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 8,304
Thanks: 99
Thanked 2,124 Times in 1,973 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Count data in a field

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.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 12-27-2018, 09:00 AM   #4
nancy54
Newly Registered User
 
Join Date: Jun 2018
Posts: 46
Thanks: 11
Thanked 0 Times in 0 Posts
nancy54 is on a distinguished road
Thumbs up Re: Count data in a field

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

nancy54 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of time data appears in field in Access kskull Queries 3 09-24-2013 02:43 AM
Access 2007 Multivalue field how to count data outrigger Queries 1 11-13-2012 12:16 PM
Form that displays a count of data based on a drop down field MrArcanum Forms 1 12-08-2009 09:54 AM
[SOLVED] Count records problem. Display field even when count is zero. DrStu Queries 3 04-13-2006 09:56 AM
Table Field Not Accepting Data From Form Function COUNT. Lamont1701 Tables 2 10-07-2005 11:24 AM




All times are GMT -8. The time now is 11:23 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World