Hello,

  I am doing an accounts application. Small company. Backend MSAccess.
Two tables are

Journal:

journalid
account_id
credit_amt
debit_amt
trdate
description

Transactions:

transid
account_id
credit_amt
debit_amt
trdate
description

Journal contains account payables and account receivables
Transactions contains payment details.

How can i generate a query to display account summary.

DATE WISE

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

Doesn't look like you have the tables defined in the most efficient form. There's no need to duplicate information in tables. You only need to be able to link the tables with foreign keys. I'm not sure what you mean by Journal, but in the simplest form you will need an accounts table and a transactions table. Every transaction will have a transid (Unique ID) and an account_id.

SELECT * from Transactions INNER JOIN Accounts ON Transactions.account_id = Accounts.account_id
WHERE account_id = " & varAccount_ID & " AND DATEPART(month, trdate) = DATEPART(month,'" & varSearchDate & "') AND DATEPART(year, trdate) = DATEPARTYEAR(year,'" & varSearchDate & "') ORDER BY trdate;

Look in the BOL for DATEPART and BETWEEN. ORDER BY by default orders by ascending