Dear Sir,
First of All Thank you Very much for your early reply. I had asked you a question regarding Microsoft Access database development problem but I could not solve my problems thus I am sending you my database and some screen shots for your kind persual. Can you do with yourself? If you can do please solve my problems and edit or modify my databases, Quries etc as you like with yourselves then send for my practice. Please find attached herewith my database and screen shots.
First of All I want to make 2 perfect queries including 3 tables names, 1-Consumers 2-Transcactions 3-Opening Balance. The calculation in first query in the Closing Balance column which is Value of Opening Balance Value of Bill Amount -(Less) Value of Credit Amount = Closing Balance. The Value of Opening Balance should be Automatically Update from the Closing Balance Column. The opening Balance Column of 2nd Row should Retrieve the Value from Closing Balance column Please see my attachments.

And in the second Query there are also 4 tables will be include names 1- Expenses 2-HPCL REG 3- Transactions 4- Consumers. After That I want to Generate a report from a query of 3-4 Tables in which I can find out the following at a Galance:
1-)Total Expenses of the day datewise.
2-)Total Bill Amount received in a whole day datewise.
3-)Total Credit Amount of the day datewise.


in Table "Opening Balance" the value of Opening Balance Should be same as Closing balance of last Transaction.
I HAVE TO update and change the value of Closing Balance. The Closing Balance of last day should be the Opening Balance of Today. How we can store the Value of "Closing Balance" Column in the "Opening Balance" COLUMN? Of Table "Opening Balance". Just Like in Excel We can call the cell reference directly if a value store in E5 and we have to retrieve the E5 value in next row i.e C6 we just type the cell reference i.e. E5 in the C6 Coloumn it will automatically retrieve the value of E-5 in the column C6. How it can be possible in Ms-Access? Please told Me WHAT TO DO? AND WHERE TO DO?

Just to let you know, I need more time to review this, but I am working on it.

dear sir,
with reference to my previous (2)emails questions, I just want to ask you a simple question for query designing if you can do with yourself please find below:
1- create a table name "xyz" fields are as under:
consumer id
consumer name
consumer account no
opening balance
purchase
received amount
balance
that's all!
I just want to manage the balance column join with account no. for example if a person whose name is "john" and his account no. is "11111" his opening balance is $500.00 and he purchase some item on credit basis for $500.00 on 15-11-2011, the balance should be $1000.00 and after that he will pay the amount after 5 days i.e.20-11-2011 $300.00 the balance amount of the row will be $700.00 because (purchase -(minus)received amount=balance)and after some days again he will purchase some item from the company for $500.00 then the opening balance should be $1200.00 and pay again $200.00 then the balance should be $1000.00 ($700.00 old $300.00 new on 20-11-2011) so how should it will calculate and maintain in query like excel. I asked you because every time the balance of every row is shown different why. How we can put up the value of balance column in "opening balance" in Microsoft access that's all. You are requested to design the database with yourself by example and send me at the earliest.kindly guide me.
thanking you,
yours faithfully,
ahtram ahemd (smaaq)

First, if you have a follow-up, please post it as an answer to this thread, don't start a new question.

Balance is not something you store, its something that is calculated. What you should be doing is posting transactions and calculating the balance. So you need at least TWO tables:

tblConsumer
ConsumerID (PK Autonumber)
Firstname
Lastname
other info about the consumer

tblTransactions
TransactionID (PK Autonumber)
ConsumerID (FK)
TransDate
TransType (Incoming/Outgoing)
TransAmount

To calculate balance you create two queries like this:

SELECT ConsumerID, TransDate, IIF([TransType]="I',[TransAmount],[TransAmount]*-1) AS AdjAmount
FROM tblTransactions;

Then use that query to create a Group BY query that groups by ConsumerID and sums AdjAmount. This will give you the balance.