T
Tom Brown
I am trying to use the following code in the Control Source property of a
text box to calculate the sum of entries made between specific dates. The
dates are fed from a user input form to an update query which puts the two
dates in a table that is read by two text boxes in a report header. The text
boxes in the report header with the dates are txt_Start_Date and
txt_End_Date. I will be copying this formula to about a hundred other text
boxes on this report so the other text boxes will be hard coded for all
other factors in the calculation. I can't seem to get the syntax correct.
The part I can't get is [Date] Between #txt_Start_Date# and #txt_End_Date#
Please help!
=nz(DSum("Activity_Count","tbl_Activity_Count","E_Number=""" & "E13207" &
""" and Activity_Code=""" & "BD" & """ and [Date] Between #txt_Start_Date#
and #txt_End_Date# "),0)
Thanks,
Tom Brown
text box to calculate the sum of entries made between specific dates. The
dates are fed from a user input form to an update query which puts the two
dates in a table that is read by two text boxes in a report header. The text
boxes in the report header with the dates are txt_Start_Date and
txt_End_Date. I will be copying this formula to about a hundred other text
boxes on this report so the other text boxes will be hard coded for all
other factors in the calculation. I can't seem to get the syntax correct.
The part I can't get is [Date] Between #txt_Start_Date# and #txt_End_Date#
Please help!
=nz(DSum("Activity_Count","tbl_Activity_Count","E_Number=""" & "E13207" &
""" and Activity_Code=""" & "BD" & """ and [Date] Between #txt_Start_Date#
and #txt_End_Date# "),0)
Thanks,
Tom Brown