Account Statement Report

[Freddie81]

Hi Guys,

I want to create reprt to enabl the user to print Mnthly statement for customrs.

I ned it to give 2 opions:

1. Print only selected customers statement
2. Print all ctiv customers statnts.

I have no idea where to start.....
I assume there A Query perhps to run the transactions for the onth?
Then to calculate the current, 30 days and 60 days filds?



Any suggestions or help wuld be appreciated need to be a openng balance calculation?

[ranman256]

Make a report to print all customers.
use the wizard and put a button on the form,
lt will ask what to do, tell it print preview report, pick the report.
This is the ALL report.

now, do it again,same thing ,then edit the code in the click event.
alter it to print the current Customer on the form,

docmd.OpenReport "rMyReport", acPreview,,"[custID]=" & me.ID