sum data in a query

[rawandjamal]

hi,
I have an access database query this query contain tow colume like this:

Input Output Balance
500$ 100$ ([Input]-[Output])=400$


good but i need when i entire a new record in the table the balance sum the current record with the previous record like this :

Input Output Balance
500$ 100$ ([Input]-[Output])=400$
400$ 200$ Current Record=200 I need to be a 600(200+400)
How i Do this help please?

[jzwp11]

If I understand you correctly, you should be able to use another query that uses the first query as its record source to do the summing.

I believe Access 2007 has the ability to select records and total them within the same query, but I have not used that feature. You might what to check the help section. In older versions of Access, you had to create a separate query to do the sum as I suggested.

[rawandjamal]

When I create another query and try to sum the record its gave me the same result only it summing the balance record with together not with a previous record I think this can happen with vba code but i dont how

[jzwp11]

Can you please provide the SQL text of the 2 queries you created as well as details on your table structure?