Hi I am creating a report via sql, that would show several incident fields and 2 fields fromn the HPD:Worklog forms. Naturally this would be a join, but I am trying to figure out which is the best way to single out the first/earliest workin info entry and exclude the rest. As you know the worklog can have more than one entry related to the single incident. Any Ideas would be helpful.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"