Setting Up a Counter

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

Guest

I have two tables. One master table with TechNo and specific info for each
technician, firstname, lastname, etc. I have another table with TechNo and
all of the tests and test dates for each technician. How do I get a total
number of technicians who have tested within a certain date? Each technician
does not necessarily take the same number of tests. We must submit yearly
"counts" for the number of technicians we have tested.

Thank you for your help. I really appreciate it.
 
How do you want to see the results? In a report? A form?

You could either create a query that counts records based on criteria or use
the DCount function to return a single value.

Barry
 
How do I get a total
number of technicians who have tested within a certain date?
Click to expand...

parameters StartOfPeriod datetime;
select count(*) from
( select distinct techno
from tests
where testdate >= StartOfPeriod
and testdate < DateAdd("y",1,StartOfPeriod)
)



Hope that helps


Tim F
 
Back
Top