Search results for query: *

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

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

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

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

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

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

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} =...

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

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

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

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

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

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