Frequency calculation

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

Hi. I have a report to track how many hours our volunteers
give a year. I've used DateDiff to calculate the Shift
hours per Volunteer. But I can't figure out how to
multiply that by the frequency. For example, if I have a
volunteer that volunteers 2 hour shifts weekly, I want to
have a total of 104 hours (if my math is correct!) a year.

How can I accomplish this? I'm thinking a calculated field
but can't quite figure it out. Thanks in advance!

Stephanie
 
Stphanie, if youm would post the applicable table structure and what/how you
calculate what you have done so far maybe someone can help.
Fons
 
Thanks for the offer. I have Volunteering table with
EventStart, EventEnd, and FrequencyID. For each
volunteer I calculate the diff between the Start and End:
=(DateDiff("n",[VolunteeEventStart],
[VolunteerEventEnd]))/60

Now I want to be able to multiply by the Frequency. So
if a volunteer is volunteering 2 hours monthly, I'd like
to be able to report that we are giving 24 hours a year
to the community. Frequency is a text field (monthly)so
I don't know if I need another field with a number (12)
or if I should use a calculated field. And I'm not sure
how to multiply in the report.
Thanks for your help! Stephanie
 
Stephanie, You can calculate in a report much like in a query. FOr instance
if you have a sum for a time for the period of One month, than you can place
an umbound textbox in your report and as the source you would type "=
[SumTime]*12"
Everything between the " " on one line. Substitute the name of your
variables as needed. Similarly you could have a Sum per week and multiply by
52 to obtain a yearly estimate.
Hope this helps.
Fons

Stephanie said:
Thanks for the offer. I have Volunteering table with
EventStart, EventEnd, and FrequencyID. For each
volunteer I calculate the diff between the Start and End:
=(DateDiff("n",[VolunteeEventStart],
[VolunteerEventEnd]))/60

Now I want to be able to multiply by the Frequency. So
if a volunteer is volunteering 2 hours monthly, I'd like
to be able to report that we are giving 24 hours a year
to the community. Frequency is a text field (monthly)so
I don't know if I need another field with a number (12)
or if I should use a calculated field. And I'm not sure
how to multiply in the report.
Thanks for your help! Stephanie
-----Original Message-----
Stphanie, if youm would post the applicable table structure and what/how you
calculate what you have done so far maybe someone can help.
Fons


.
Click to expand...
Click to expand...
 
Thanks for the help. I may not have used the most
streamlined solution, but the report gives the figures I
need. Thanks- I appreciate the lesson. Stephanie
-----Original Message-----
Stephanie, You can calculate in a report much like in a query. FOr instance
if you have a sum for a time for the period of One month, than you can place
an umbound textbox in your report and as the source you would type "=
[SumTime]*12"
Everything between the " " on one line. Substitute the name of your
variables as needed. Similarly you could have a Sum per week and multiply by
52 to obtain a yearly estimate.
Hope this helps.
Fons

Stephanie said:
Thanks for the offer. I have Volunteering table with
EventStart, EventEnd, and FrequencyID. For each
volunteer I calculate the diff between the Start and End:
=(DateDiff("n",[VolunteeEventStart],
[VolunteerEventEnd]))/60

Now I want to be able to multiply by the Frequency. So
if a volunteer is volunteering 2 hours monthly, I'd like
to be able to report that we are giving 24 hours a year
to the community. Frequency is a text field (monthly) so
I don't know if I need another field with a number (12)
or if I should use a calculated field. And I'm not sure
how to multiply in the report.
Thanks for your help! Stephanie
-----Original Message-----
Stphanie, if youm would post the applicable table structure and what/how you
calculate what you have done so far maybe someone can help.
Fons

:

Hi. I have a report to track how many hours our volunteers
give a year. I've used DateDiff to calculate the Shift
hours per Volunteer. But I can't figure out how to
multiply that by the frequency. For example, if I have a
volunteer that volunteers 2 hour shifts weekly, I
Click to expand...
want
to
have a total of 104 hours (if my math is correct!)
Click to expand...
a
year.
How can I accomplish this? I'm thinking a
Click to expand...
calculated
field
but can't quite figure it out. Thanks in advance!

Stephanie

.
Click to expand...
Click to expand...
.
Click to expand...
 
Back
Top