I am doing an accounts application. Small company. Backend MSAccess.
Two tables are
Journal contains account payables and account receivables
Transactions contains payment details.
How can i generate a query to display account summary.
suppose, i have 3 purchase invoices in the month Jun, 2006 on dates 1, 7, 15
And I made payments on 6, 9 and 25
The report must show from these two table of the account_id order by date(ascending)
Can anyone help me?
How can I pass parametr to a query in MSAccess from asp.net?
thanx in advance