Unanswered: Query using the totals (sigma) last feature
payroll data with the following fields.
employee id (E_Id)
pay rate date (PRD)
pay rate $ (PR$)
i have ran a query (q1) which sorts the data by E_ID, then by PRD.
i then used a second query (q2) drawing from the first query (q1).
within q2 i am trying to group the data and obtain the most recent pay rate which is from the most recent date.
now i have tried using the totals (sigma) feature in access.
however, this does not give me the results i am looking for.
E_Id PRD PR$
3215 20090727 25
3215 20100101 33
sometimes i get the last record and sometimes i do not.
in this case using last i was expecting the following record.
thanks for putting me there. talk about a useless feature in MS access.
unfortunately i do not know enough about programming for modules to permit me to do what i am looking for when using method #3.
however, now that i know a work around, i am on my way.