F
Flopbot
Here it goes. I'm a first time questioner and new to Access so I don't know
anything about coding, queries, etc. Hopefully someone can help this poor
lost sole. I have a form that’s based on my “Volunteer Info Tableâ€. This
table is linked (one-many) to “Volunteer Hours Tracking Form†via primary
key. I would like to add an expression in a control box on the form that
will do two things. 1.) Include those records with the correct primary key.
2.) Sum only the past year’s records found in the “Total†column on the
“Tracking†form. The Total column is a calculated column using the following
function which works beautifully by the way =([End Time]-[Start Time])*24).
That calculation results in the total hours volunteered each day. Does
anyone know an expression that I can use to do this? I think it might be
some combination of =Sum() & <Date()-365. Thank you so much to anyone that
can help!!!!
anything about coding, queries, etc. Hopefully someone can help this poor
lost sole. I have a form that’s based on my “Volunteer Info Tableâ€. This
table is linked (one-many) to “Volunteer Hours Tracking Form†via primary
key. I would like to add an expression in a control box on the form that
will do two things. 1.) Include those records with the correct primary key.
2.) Sum only the past year’s records found in the “Total†column on the
“Tracking†form. The Total column is a calculated column using the following
function which works beautifully by the way =([End Time]-[Start Time])*24).
That calculation results in the total hours volunteered each day. Does
anyone know an expression that I can use to do this? I think it might be
some combination of =Sum() & <Date()-365. Thank you so much to anyone that
can help!!!!