Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by HelenNY

  1. HelenNY

    Next Functions and Aggregate Functions

    LBASS - You rock!! I spent several hours trying to figure this out and couldn't get the totals working. Thank you so much!!!
  2. HelenNY

    Next Functions and Aggregate Functions

    Thanks lbass, but I'm not sure I follow, or maybe I didn't clearly explain my question. I'm trying to get the net projected pay for the year. So for each record, I need to find the next pay rate's start date so I can calculate the total pay for each "period". 1234 , 01/01/2011 , 50.00...
  3. HelenNY

    Next Functions and Aggregate Functions

    I have a table with pay rates and effective dates in it and I need to calculate the total pay for the period based on the effective dates. Here's an example of the data for an employee: Employee, Effective Date, Amount 1234 , 01/01/2011 , 50.00 1234 , 03/01/2011 , 52.00 1234...
See more

Part and Inventory Search

Back
Top