Thanks LJ.... -------------------------------------------- On Wed, 1/7/15, LJ LongWing <lj.longw...@gmail.com> wrote:
Subject: Re: Determining first workinfo entry To: arslist@ARSLIST.ORG Date: Wednesday, January 7, 2015, 4:37 PM ** do a MIN on the create_date for the work log entry...this'll ensure you only get the first entry. On Wed, Jan 7, 2015 at 2:33 PM, Scott Hallenger <vadr...@yahoo.com> wrote: 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" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
