Access Reports count();

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Marks
    New Member
    • Dec 2007
    • 21

    #1

    Access Reports count();

    Howdy,
    Need some help on this one.... need to get access to count the number of records have a value of "Completed" in field1 and repeat on with other values...
  • nico5038
    Recognized Expert Specialist
    • Nov 2006
    • 3080

    #2
    Check out the GroupBy query in the helpfile.
    Pressing the "E" looking button will give you the query as a groupBy and experiment with the "GroupBy" and "Count" you can add underneath the fields.

    Nic;o)

    Comment

    Working...