example
Header Details
customer No: xyz
From Date : 01-01-2007
to Date : 01-12-2007
cust Open Bal : <sum(credit-debit) before From Date i.e 01-01-2007>
================================================== ======
Line Details
Description Date Debit Credit
Debit 20-01-2007 2000 0
Credit 21-01-2007 0 1000
----------------------------------------------------------------------------------------------------------------
Total (Debit - Credit)
----------------------------------------------------------------------------------------------------------------
here what i want, credit of customer in last 30 days how much and in 60 days how much and 90 days how much
30 days Credit 60 days credit 90 days credit
100 500 400
please help me to create a query to get 30, 60 and 90 days credit amount
awaiting
Could you provide more detail on what exactly you want in your report?
More information (columns required, sample data) ?