Count

  • Thread starter Thread starter Dsperry101 via AccessMonster.com
  • Start date Start date
D

Dsperry101 via AccessMonster.com

I have a database that has a field "Work orders received" in date format.

I would like to generate a list of count of work orders received each day

ie. 22 Jan 2006 has 12 workorders
23 Jan 2006 has 10 workorders
etc.
Can I use the count function to do this or do I need to do in
VBA ??

Thanks
 
You can use DCount if you need to do any one specific date. Otherwise use a
totals query.

Create a new query
-- Select your table
-- Select your field and put it in the grid TWICE
-- Select View: Totals from the menu
-- Under one reference to the field, change GROUP BY to COUNT
 
John

Wow , that was easy !! Feel like a dummy but ya gotta start somewhere !
I'll probably be on here again.

Thanks

Dan Sperry

John said:
You can use DCount if you need to do any one specific date. Otherwise use a
totals query.

Create a new query
-- Select your table
-- Select your field and put it in the grid TWICE
-- Select View: Totals from the menu
-- Under one reference to the field, change GROUP BY to COUNT
I have a database that has a field "Work orders received" in date format.
[quoted text clipped - 8 lines]
 
No need to feel like a dummy. We all start somewhere and its almost always
looks easy once you know how.

Dsperry101 via AccessMonster.com said:
John

Wow , that was easy !! Feel like a dummy but ya gotta start somewhere
!
I'll probably be on here again.

Thanks

Dan Sperry

John said:
You can use DCount if you need to do any one specific date. Otherwise use
a
totals query.

Create a new query
-- Select your table
-- Select your field and put it in the grid TWICE
-- Select View: Totals from the menu
-- Under one reference to the field, change GROUP BY to COUNT
I have a database that has a field "Work orders received" in date format.
[quoted text clipped - 8 lines]
 
Back
Top