Complex Select Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got a table with 20 fields, 8 of which comprise the primary key. A field
called EndBal (stands for Ending Balance) contains the dollar amount. I'm
trying to calculate a field called BegBal (Beginning Balance). I also have a
field called YrPrd which is a long integer that describes the Year and Period
Number of the transaction (for example 200212, 200301, 200302, etc).

Logically, I believe I should be able to get BegBal by joining the table to
itself (using the 8 keys) and summing EndBal for all records where
MyTable.YrPrd is less than TempTable.YrPrd. Thus far, I'm not able to put
together a query that does this - any help?
 
Running balances are real easy to generate on a report, but not at all easy
to do in a single query.
 
Back
Top