Unanswered: Calculating Totals of multiple fields in 1 query
I am trying to write a query that will give me the totals of a few different fields based on a name and date on an open form...ie:
startup form has "SUPERVISOR" and "DATE" drop down boxes. based on the selected supervisor and date it would count the number of field one, field 2, field 3 etc for every person who is assigned to the selected supervisor.
example of what I want it to do:
select count(stops), count (starts), count(jumps)
from [daily reports]
where [daily reports].supervisor=forms!startup!supervisor and (datepart("m", [date]= forms!startup!date)