Not printing all of the customers Statements

[waredata]

Database consit of Customers with Charges + payments

I'm trying to create statements on these customers. Base on Between dates

Such as BegDate:03/1/11 EndDate 03/31/11

Should show a statement for every customer that has a balance.
But it don't.

Statement: BegBal (1 day before BegDate for total) +Charges/tax-Payment = grand total

What do you need from me? I'm doing this in 2007.
Thanks

 

[DCrake]

If you run the undelying query that the report is based upon does this show all the customers?

 

[waredata]

yes it does..

It needs to run a statement if only they have a begining balance and a ending balance.

What I see are only those that has charges during the month I'm asking for.

 

[DCrake]

So what you are saying is that you can see a record appearing in your query that does not appear in your report.

If so this sounds dodgy as the report is generated by the query. I would double check your previous statement

 

[waredata]

This is trhe first run on Access. They were done on a ASA400 format last month.
Thats why I added the balances from last month, into this one.