G
Gator
I have a form that displays fields RealTax2007, RealTax2006, RealTax2005 and
Date. What expression can i use in a textbox that will show me a single SUM
of all the records in the table for the month and year displayed in the Date
field currently displayed on the Form for all the " Real* " fields. In other
words, as I scroll through records on the form, whatever date is displayed, a
textbox will display a SUM of all amounts in the records for that particular
month and year....the single SUM would include RealTax2007, RealTax2006,
RealTax2005 for record 1 for the month of June of 2008 as well as record2,
record3...etc.....So, all resords with fields with "Real" in the name for the
month and year of the month and year displayed on the form will add to an
amount in a textbox.
Date. What expression can i use in a textbox that will show me a single SUM
of all the records in the table for the month and year displayed in the Date
field currently displayed on the Form for all the " Real* " fields. In other
words, as I scroll through records on the form, whatever date is displayed, a
textbox will display a SUM of all amounts in the records for that particular
month and year....the single SUM would include RealTax2007, RealTax2006,
RealTax2005 for record 1 for the month of June of 2008 as well as record2,
record3...etc.....So, all resords with fields with "Real" in the name for the
month and year of the month and year displayed on the form will add to an
amount in a textbox.