Search results

Thanks Pbaldy -- I had been working much too long yesterday, thank you for your help !!

My thinking must not be right as I can't get this to work but i have a table with Date AMT 02/05 50 02/06 20 and soforth.... I am summing up each week and putting this in a table with values WeekBeginningDate WeekEndingDate SumofAmt I am trying to do INSERT INTO tblTwo...

Okay, I figured this out (finally). Here is what worked in acccess for me: SELECT a2.TDate, a2.Amt, (select sum(amt) as total from tblDailySummary WHERE TDate <=a2.TDate ) AS Total FROM tblDailySummary AS a2;

Brian, the access help tells how to sum, I am doing this programatically and need to do a sum of the original sum. The access help does not mention this and is related to the design wizard, but thanks anyway...

Hi All, I have a table that has mulitple rows for each date with an amount. I want to sum the amount by date, then have a running total of that sum: Current table: Date Amount 4/25 10 4/25 20 4/26 15 4/26 30 The output I want would be: Date Amt Total 4/25...

Jon, Thanks so much!! Solved my problem.

Thanks Ryko, but in my table I have only one column for TYPE which contains either 'S' or 'L'. In my output I want two separate totals - one 'Longs' and one 'Shorts'.

I have a problem I need some help with. I have a table that keeps trades for the day: TDate TTime Type Amount. The type is L for Long, S for short. Multiple trades occur each day. I want to summarize each day to a single record: Date TradeCnt Longs Shorts Amount My problem is how do I...