I am creating a new report, which is actually a Ledger by Customer. I start the report from a form. The form provides a choice on how to sort the report by G/L Date/by Invoice Date/by Transaction Date.
The data is provided to the report by a query.
I have the following questions:
1) Can I specify in the query to sort the data based on the choice made in the form. eg. by G/L Date, by Invoice Date or by Transaction Date. or do I need separate queries for each sorting option?. (Most probably there is an IIF statement , but I dont know how to use it.)
2) I need to start a new page for each Customer. If the Customer number changes, I need to start a new page.
3) I print a debit and credit column on the report. I need to add a running subtotal by customer.
eg
DEBIT CREDIT BALANCE
65.00 65.00
10.00 55.00
a) how do I calculate the balance based on the debit, credit fields in the report..
b) the balance needs to be reset to 0 when the customer number changes.
As always all help is greatly appreciated.
Thanks
Sarah
Posted by: sarahk@schemesoftware.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar