I am working with the table builder using MSNAV "Employee Rate" table. The table stores the wage for the employee and the effective date. There are multiple dates and rates for each employee as they change jobs and receive raises. How do I limit the wage data so I only get their most current effective data and wage?
Thanks,
Christine
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Christine -
While it is possible to get the first matching record from a transactional table using Express (this is accomplished by using a header table as the first table and a transactional table as the second table), it, unfortunately, is not possible to get the last (or "most recent") record.
-HP -
Jet Reports Historic Posts Is it possible in the full verion of the software?
-
Jet Reports Historic Posts Hi Christine -
Jet Essentials provides other tools [beyond the NL(Table) function] that would provide greater ability to get to this data.
Using those tools, one could get the last entry for a particular criteria.
-HP
Please sign in to leave a comment.