Count of dates in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table showing multiple time sheets that are working in different
jobs or the same job, what I want to find out is how many days the job was
worked on. Not by how many people but just the number of days the job was
active. The table has idno, date, employee, job, hours etc.. I want the
number of days that the job was open. Am I asking for to much?
 
Are you saying you want a count of unique days for each job? Where does
"job was open" come in -- how are you indicating that?

A Totals query, grouped by job and counting dates should do it. You'd
probably need to start with a query that returned only unique combinations
of job & date, though, then use a second query (the Totals query) to do the
counting.

Regards

Jeff Boyce
<Office/Access MVP>
 
Thank you Jeff I am always so amazed at how helpful everyone is. I hope to
get there some day.
 
De nada ... I'm sure you already "are there" for some of the folks who post
in the 'groups.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top