Calculated Field for Running Total

[terces]

Hi,

I am new to access and created a db thru e-learning. I need assistance on query criteria for running Total in computing finances on one of my query.
Here are the following informations you might want to know.

tblFinancial
-finID (autonumber)
-finGrant (currency)
-finChkDate (date/time)
-finChkNo (number)
-finChkAmt (currency)
-finUnreleased (currency)
-finJevNo (number)
-finJevAmt (currency)
-finTotalLiq (currency)
-finBal (currency)

where:

finGrant is the approved fund for the project which comes in different tranches

finChkAmt is 1 tranche released check based on check no.

finUnreleased is finGrant less finChkAmt

finJevAmt is liquidation amount (entry varies which is based on check no.)

finTotalLiq is the summation of finJevAmt based on check no. (this could be a running total so one entry per check no.

finBal is finChkAmt less finTotalLiq


Hope somebody would help.

Thanks
Terces

 

[Trevor G]

Welcome to the Forum,

First create a query based on your fields. Then Save the query after viewing the data to see if you are looking at the correct data.

Next create another query based on the first query and then look to add totals. You can then Group by Check No and then use SUM for the fields you want to total on.

 

[terces]

Thank your for your quick reply...the first query is done named qryFinancial, though i dont know about the second query and how to do those things you have mentioned. (sorry no idea =[) do you have any codes or something? =D

I am attaching you "my" work of art =]...coz I have been self studying access for 2 months.

 

[Trevor G]

look at this screen shot to show you where the totals icon is and also how to select.

Also Press F1 (Help) and type in query totals

 

[terces]

yea i got that...how bout the sql? after i put on sum on totals.. i can't entry data to the form.

attached here is the excel sheet for what i want my access table to be look alike or is somebody has a better idea on how to make this better ill be glad to hear it.

 

[Trevor G]

In your thread you asked for help with a query, now your saying you want help with a form and SQL?

If you want the SQL from the query then open the Query in design view and then select to Vew the SQL code from the View Menu.

May I suggest you consider what you are actually trying to achieve and place that in your thread.

 

[terces]

sorry for the misuse of words, i have uploaded the excel file, i want the query to work like that and attaching the db file for this but i have difficulty in fixing it.

I prefered the Select clause (please take a look at the attachment) than the Dsum

Thanks