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!

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

Search results for query: *

  1. IamnotCharles

    List Deduction codes on one row

    I would not exclude duplicate rows. If there are duplicates, they need to be investigated. As an example, if an employee had the identical deduction code and amount for a single paydate, something may be wrong. It could possibly be a manual check that was updated, or there was a double...
  2. IamnotCharles

    New to RS: Duplicates

    It's probably because of the way the data is layed out in the view you are choosing. If you're using the V_Benefits table, a row of data will be returned for each Benefit Type assigned to an employee. Even if you restrict the benefit types in the selection criteria, it will return as many rows...
  3. IamnotCharles

    Derived Fields by Effective Date of Table, as it were

    If you can base it on the system date when the report is run, you should be able to do something. If this is an ADP SQL database, you can use the @now function in date/time function. Then, you can use the @month command. So, your first calc may be @(month(@now))......then, you can use the...
  4. IamnotCharles

    Most Recent Title change date

    Another way to do this would be to sort the report alphabetically, then by change date. Create a group and footer by name. Insert name, job title and change date in the footer. It will display the latest change date information. Then, you can hide the detail by clicking on format, section...

Part and Inventory Search

Back
Top