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 derfloh 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. Tdharris

    Select Statement SQL Server 2008

    I'm working with a select statement that is supposed to identify claim id's that are not present in two separate tables. It runs successfully, but leaves off records that I know are not present in both tables. One table (CLAIMS) has only one instance of the ID the other (CLAIM_PROCS) can have...
  2. Tdharris

    Visible=False Pivot Table Macro

    Thanks Andy! It worked PERFECTLY! TDH Business App System Analyst Information Technology
  3. Tdharris

    Visible=False Pivot Table Macro

    I am using Microsoft 2010 Thanks, TDH TDH Business App System Analyst Information Technology
  4. Tdharris

    Advanced Mail Merge (Word 2007)

    Thanks Paul, I will fix the brackets right away and also include the Next Page section breaks. TDH TDH Business Application Specialist
  5. Tdharris

    Advanced Mail Merge (Word 2007)

    I would like to merge 1 data source to multiple letter types, envelopes, and receipts with one main merge document. Which is the best way to do it? Using merge fields, macros, code? I have been unsecessful using a main document that includes the {if{MERGEFIELD Letter Code}="Receipt Less Than...
  6. Tdharris

    Date Difference

    Thanks again for the help. I will give it a try. TDH TDH Business Application Specialist
  7. Tdharris

    Date Difference

    This formula works awesome getting me the date frequency in the details. However, I have been trying to put it into a crosstab summary in the report header per activity code. Here is the formula as it is written now in the details. if not onfirstrecord and{ACTDEFN.ACTCODE} =...
  8. Tdharris

    Date Difference

    Nevermind, not sure why it didnt work at first! Works fine! Thanks again LB! :) TDH Business Application Specialist
  9. Tdharris

    Date Difference

    I keep getting "too many arguments have been given to this function" - formula: if not onfirstrecord and {ACTDEFN.ACTCODE} = previous({ACTDEFN.ACTCODE}) and GroupName ({COMPLAND.UNITID}) = previous({COMPLAND.UNITID}) then datediff("d", previous({HISTORY.COMPDTTM},{HISTORY.COMPDTTM})) TDH...
  10. Tdharris

    Date Difference

    Thanks LB, is there a way to get the difference per instance? Calculate the timeframe between each date an activity was performed. For example: 9/2 9/16 - 8 Days 10/5 - 19 Days 10/25 - 20 Days Thanks for your help- you are awesome! TDH Business Application Specialist
  11. Tdharris

    Date Difference

    I need to find the difference between dates each time an activity was performed. My report is grouped by unitid(location), then ActivityCode(activity perfomed at the location). I need the difference of the {HISTORY.COMPDTTM}(date the activity was completed)for each instance of each location...
  12. Tdharris

    Subreport Errors

    Thank You, I was leaning toward 3 subreports and will definately give it a try with the main only containing employees. Thanks again TDH TDH Business Application Specialist
  13. Tdharris

    Subreport Errors

    I have a timesheet report that captures three different types of leave from 3 different databases. The main report contains one type of leave and two subreports capture the other two types. The reports are joined by employee id #'s and have a date range parameter. The issue I'm having is, if...

Part and Inventory Search

Back
Top