Search results
-
K
Solved Need help with Query
I have 2 tables tblJob & tblJobSession, pic attached I would like to show all Jobs with open jobsessions , but only the last visit so out of the table tblJobSession i would like to only show RecID 2 and 3 data to return would be tblJob.JobID , tblJob.Reg , tblJob.JobType ... -
K
SQL Group By problem
I have data that i want to list in a grid. it contains the following data structure GroupID, PartNumber, PartDesc , Date_Out, Date_In, History ,Log_Date when a job is opened on date_Out it gets given a GroupID (number) so that i know each history update this record belongs too. ie. 1 ...