Count

  • Thread starter Thread starter margaret
  • Start date Start date
M

margaret

I have a report with an emp and time entries. I want to
know how many total "emp"'s I have. However, if I do a
=Count([emp]) because an employee may have 5 time entries,
it's counting all of those as opposed to just one
employee. So my report is giving me "122" "emp" when it
should give me "30".

Any ideas?
 
Ignore this ... I did a search and "Griff" and "Steve" had
already answered this question earlier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tuff Query help 2
macro??? 1
Compare tables: Trace diff records 10
Form/subform worries 2007 1
DCount improper use of null 1
Sorting by a calculated field summary 5
how to count 1
Add Hours by Looping through Data Q 27

Back
Top