Search results

  1. T

    How to INSERT INTO values and select...

    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...
  2. T

    How to sum a sum...

    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...
  3. T

    Help with Query -- Count ??

    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...
Back
Top Bottom