G
GaryDennis
I am trying to make a form display the results of input for 3 separate
periods of time for different locations. Here is what the form/fields
represent:
Location: in this field are the names of different offices.
Number of Surveys: In this field a number is entered representing the
quantity of surveys performed at each location for the week. From here, I
need to calculate the number of surveys taken within the quarter, then the
number of surveys taken during the year. From there, I need to find the
cumulative or grand total of all weekly, quarterly and yearly sums for all
of the offices. I tried using a formula in a query, but I cannot get the
query formula(or name) to work as the control source on the form.
Thank you for your help.
Gary
periods of time for different locations. Here is what the form/fields
represent:
Location: in this field are the names of different offices.
Number of Surveys: In this field a number is entered representing the
quantity of surveys performed at each location for the week. From here, I
need to calculate the number of surveys taken within the quarter, then the
number of surveys taken during the year. From there, I need to find the
cumulative or grand total of all weekly, quarterly and yearly sums for all
of the offices. I tried using a formula in a query, but I cannot get the
query formula(or name) to work as the control source on the form.
Thank you for your help.
Gary