C
chickalina
I have a query that has many fields. I have (from the table)
qry_ReserveSchedule-Form
IssueID
ChangeDate
Date: Format([changedate],"q-yy")
PrvQtr: Format(DateAdd("q",-1,[changedate]),"q" & "-" & "yy")
Then all the fields are listed where the user can enter a value.
I also have a CrossTab Query, based on the same table:
qry_ReserveSchedule_Subform
IssueID
PrvQtr: Format(DateAdd("q",-1,[changedate]),"q" & "-" & "yy")
Total:
Sum(([BeginningBalance]+[T-Acquisition]+[T-OtherBalSht]+[TaxReversal]+[TaxAccrual]+[T-OtherProvision]+[T-Reclass]+[T-Cumulative]+[Payments/Refunds]+[T-OtherBal]+[tbl_ReserveSchedule]![I-Acquisition]+[tbl_ReserveSchedule]![I-OtherBalSht]+[tbl_ReserveSchedule]![InterestReversal]+[tbl_ReserveSchedule]![InterestAccrual]+[tbl_ReserveSchedule]![I-OtherProvision]+[tbl_ReserveSchedule]![I-Reclass]+[tbl_ReserveSchedule]![I-Cumulative]+[tbl_ReserveSchedule]![I-OtherBal]))
Total is a total of all the fields, so that it can sum by quarter....
What I have right now is a report that pulls the Quarter a user wants to see
from a form. This works fine and is based on the qry_ReserveSchedule-Form. We
can see all the records with information in that particular quarter... I want
to use the subform to total everything prior to that quarter to get a
previous ending balance (which means sum<[date])...
So if the Previous Quarter balance is 100 and current is 25, a text box on
the report would total previous + current and get a Ending Balance.
What is the correct way for me to to this.????
Any suggestions?
qry_ReserveSchedule-Form
IssueID
ChangeDate
Date: Format([changedate],"q-yy")
PrvQtr: Format(DateAdd("q",-1,[changedate]),"q" & "-" & "yy")
Then all the fields are listed where the user can enter a value.
I also have a CrossTab Query, based on the same table:
qry_ReserveSchedule_Subform
IssueID
PrvQtr: Format(DateAdd("q",-1,[changedate]),"q" & "-" & "yy")
Total:
Sum(([BeginningBalance]+[T-Acquisition]+[T-OtherBalSht]+[TaxReversal]+[TaxAccrual]+[T-OtherProvision]+[T-Reclass]+[T-Cumulative]+[Payments/Refunds]+[T-OtherBal]+[tbl_ReserveSchedule]![I-Acquisition]+[tbl_ReserveSchedule]![I-OtherBalSht]+[tbl_ReserveSchedule]![InterestReversal]+[tbl_ReserveSchedule]![InterestAccrual]+[tbl_ReserveSchedule]![I-OtherProvision]+[tbl_ReserveSchedule]![I-Reclass]+[tbl_ReserveSchedule]![I-Cumulative]+[tbl_ReserveSchedule]![I-OtherBal]))
Total is a total of all the fields, so that it can sum by quarter....
What I have right now is a report that pulls the Quarter a user wants to see
from a form. This works fine and is based on the qry_ReserveSchedule-Form. We
can see all the records with information in that particular quarter... I want
to use the subform to total everything prior to that quarter to get a
previous ending balance (which means sum<[date])...
So if the Previous Quarter balance is 100 and current is 25, a text box on
the report would total previous + current and get a Ending Balance.
What is the correct way for me to to this.????
Any suggestions?