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: *

  • Users: MHurdatADP
  • Content: Threads
  • Order by date
  1. MHurdatADP

    Outer Join Not Working-Enterprise/Autolink

    I'm joining JOB to AL_ALA_DATA. I want everyone's job data, even if they do not have an entry in AL_ALA_DATA. However, when I add AL_ALA_DATA and link it to JOB, I lose the unmatched records, even though I have checked "show unmatched records" for both file number and paygroup links from JOB to...
  2. MHurdatADP

    Fidelity 401K Interface

    I'm at a client who uses a custom SQR - which ADP charges them for each time it is run - to produce its Fidelity interface. The output is in fixed field length and multiple "records": one for name, one for address, one for city/state/zip, one for 401K data, which means they have multiple rows...
  3. MHurdatADP

    Compare Summary Values

    This is Enterprise V4, RS 3.10. I have two columns, one with REG hours, the other with OT hours. I can create a derived field which compares OT hours to REG hours at the detail level as a percent (OT/REG). I can sum the REG and OT hours columns by dept or paygroup. Is it possible to compare...
  4. MHurdatADP

    Compare Crosstab Columns

    I want to compare overtime hours to regular hours; overtime earnings to regular earnings. I have columns for OT hours and REG hours, earnings as well. Can I compare two columns in Crosstab? Or must I use a derived field? Problem with a derived field is that I get no rows, because OT...
  5. MHurdatADP

    Too much history

    Earlier, I had a thread where I got "no rows found" when trying to display current JOB row and previous JOB row, when no history existed. I found a fix for that: include a condition where the history effdt is either null or equal to the current row. However, that adds a new problem: Where...
  6. MHurdatADP

    Graph Function

    I tried the Graph function. No luck. I get a message "Microsoft Word Graph not installed. Please reinstall Microsoft Word" or something similar. This is RS 3.11 in ADP Enterprise version 4B, hosted. Anyone ever successfully use the graph function in this environment?

Part and Inventory Search

Back
Top