Recent content by nasir

Sorry for disturbing you again. I have the following Table: Transactions(TransactionID, TransactionDate, Particulars, ChequeNo, AccountNumber, AccountTypeID, WithDrawalAmount, DepositAmount) TransactionID is the primary key. I want to calculate Running Balance of a specific AccountNumber by...

Sorry for taking a while to get back to you. Thank Ian its working Thanks a lot. Nasir ___________________________ Love 4 All, Hatred 4 None

I couldn't create report of this query? I want to create report by AccountNumber when I tried I got this message "Multi-Level GROUP BY Clause is not allowed in a subquery"? What is the solution of this problem? Please Sir?

Respected IAN MAC Thank You so much for co operation. May God help you in every difficulty and keep you under His Blessings. I was struggling to solve problem for so many days. It work. Really Thanks Nasir www.nasir.co.nr nasiramd@hotmail.com

I have two tables ACCOUNTS with fields (AccountNumber, Name, AccountTypeID, Address, Phone, Date A/C Opened) And TRANSACTIONS (TransactionID, TransactionDate, Particular, ChequeNo,AccountNumber,AccountTypeID, Rate, WithdrawalAmount, DepositAmount) I created a query based on these two tables...