Getting a brought forward figure before compling a report

[bwian]

Hi, I have a largish client base that I offer services to. I keep all the invoicing & payments on access. I am trying to add a facility to produce a statement.
I have a field on my main client form that I put a date them click the statement button and I get a statement from that date to present. this all works fine.
However I need a brought forward figure a the beginning of the report. So if the report started on 1st Oct, I need to know what the balance was at 31st Sep.

the fields I have are: - 'Invoice no', 'Date', 'Details', 'Method', 'Amount', 'Payment'

Can I use the Query to do 2 queries, the first to add up the 'Amount' and 'Payment' fields up to the starting statement date, then total them and take one from the other to get the balance. Then Run my normal queries and have the figs put on the same report.

I hope I've explained this correctly

thanks in advance
Bwi.

[aytee111]

Queries are another form of data "storage" and can be used as input to further queries. My method of creating data in this manner to keep queries simple, each one performing one function, which often requires doing multiple queries to get to the final result.