Basically I have two major tables: Customers info & data
I'm trying to create statements base on the data per month.
Statement would have Beg Total (prior month ending total), current month charges - payments + taxes = Ending Total
I use a ([BegDate]And[EndDate] on [Date Posted])to show current month activities.
However if there is no charges between thoes dates on any customers accounts, but have a outstanding balance. My report won't print out a statement. Only those with activities during the current month.
Query: BegTotal i uses <1[BegDate]
Current charges for the month
Any payment made during the month
Taxes posted for the month
Ending Total.
I really am lost.. I need to run all customers statements.
I know I am a newbe, just any suggestion

I'm trying to create statements base on the data per month.
Statement would have Beg Total (prior month ending total), current month charges - payments + taxes = Ending Total
I use a ([BegDate]And[EndDate] on [Date Posted])to show current month activities.
However if there is no charges between thoes dates on any customers accounts, but have a outstanding balance. My report won't print out a statement. Only those with activities during the current month.
Query: BegTotal i uses <1[BegDate]
Current charges for the month
Any payment made during the month
Taxes posted for the month
Ending Total.
I really am lost.. I need to run all customers statements.
I know I am a newbe, just any suggestion

