Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Papa
Starting Member
5 Posts |
 Posted - 2004-11-24 : 16:23:35
|
OK. Access 97.RE: Running Total on a Form ----I'm another newbie at this, so don't get frustrated.Table name: SalesAmong other fields on my form, there are 3 fields that concern this scenario:1. Profit (Sell minus Cost) That works fine.2. Shipping_Profit (Shipping charge + Actual Shipping) That works fine.3. Total_Profit (Profit plus Shipping_Profit) It gets its total from Profit + Shipping_Profit. That works fine. 4. Profit_To_Date (a running total of Total_Profit) It SHOULD update for each record, but I can't get it to do it! Now....I understand that Total_Profit is a calculated field. My problem is I don't yet understand how to build an expression for Profit_To_Date because it's based on a calculated field.I've been referred to the Microsoft site via URL's, but I need a simpler explanation. An simple example would be highly appreciated. Remember, I want this for a FORM and not a query or report.Thanks to anyone who can help... |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-11-24 : 16:30:19
|
| Papa,can you post some sample data and an example of your desired output? |
 |
|
|
Papa
Starting Member
5 Posts |
Posted - 2004-11-24 : 20:01:40
|
| Sample Data:Record 1:Cost: $100.00Sold: $ 50.00Profit: $ 50.00Shipping Charged: $15.00Shipping Actual: 12.00Shipping Profit: 3.00Total Profit: $53.00Profit to Date: $53.00 <-- this amount should increase/decrease with each following record, based on Profit + Shipping Profit. I would like to have this on my form. I've been trying to figure this out for 2 days!Any sample expression would be appreciated. I don't understand technical stuff about this. I just want it to work.Thanks again. |
|
|
|
|
|
|
Yet Another "Running Total" Question!