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 Rhinorhino 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: funscrapn
  • Content: Threads
  • Order by date
  1. funscrapn

    Include unmatched records

    I am trying to create a report that will list the employees general deductions from the GENL_DEDUCTION table and the deduction from the employees pay check from the PAY_DEDUCTION table. The problem is that if the deduction is not listed on the PAY_DEDUCTION table (because nothing came out of...
  2. funscrapn

    One check date per column

    I am trying to create a report which will be pulling 4 to 5 check dates (depending on the month). Each check date needs to be in it's own column. Does anyone know how to accomplish this? Thanks!!!
  3. funscrapn

    Crosstab - Suppressing lines

    I am creating a Crosstab report and want to be able to suppress lines where the count = 0. Is there an option when creating the report that does this the key here is it's a Crosstab and the totals are created by the Crosstab function.
  4. funscrapn

    Order By Derived Field

    Hi, I have created a report that pulls the history rows of the JOB table. Now I need an Order By or Row Number derived field. I have been unable to create this. Any suggestions? The background on this report is that I only want the last 5 rows from the history of the JOB table. Unfortantly...
  5. funscrapn

    Only thousand place digits wanted

    Hi, I have a derived field set up to take the annual rate and times it by certain numbers. I want to then take that total and I want it to just give me the first three digits in the thousands place. For example, if the derived field returns anywhere between 1,000 and 9,999 I want it to return...
  6. funscrapn

    Fixed Length Derived Field

    I have created a fixed length derived field Rtrim(fieldname, length) and am trying to save it as a txt file. However, when I save this as the txt file it is not retaining it's format, and does not seem to matter that I click the retain format button. Does anyone have any suggestions as to how...

Part and Inventory Search

Back
Top