Recent content by K_ZEON

tks. just to advise this was a stripped down query , in my main app, the query has a lot more data from other tables. I wanted to get a base line then add in the rest bit by bit so in the end i will have all the data returned that i need.

sometimes a jobsession could still be open ie engineer has done an update for visit 1 but not fully completed ie closed. could be at Further work. then a new visit is created which is open but the first visit it not manually closed. In this scenario it would show both visits hence why i only...

Hi. tks for the input. I need to show only Jobs that have an open Visit and each time engineer attends site a new visit is added and marked as open. previous visit is closed. So the previous code in post #6 does what i need and i will take this example and hopefully expand to include more data...

tks, works as expected, now to see if i can expand from this example to a bigger query as this was just some of the data. if i get stuck, i hope i can post again. tks for the quick help

yes i tried group by but not able to get what i need.

tks, just pasted into Access but does not work. I have tried to change the names to the correct tables but not sure what to do with MaxV ? sorry but i dont really do a lot of sql except basic quesries. If you could , could you show how i would adjust this to match my tables. it gives error...

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

my bad. sorry did it that way for quickness SELECT Parts_History.GroupID, Parts_History.PartNumber, Parts_History.PartDescription, Parts_History.Date_Out, Parts_History.Date_In, Parts_History.History, Parts_History.Log_Date FROM Parts_History GROUP BY Parts_History.GroupID ORDER BY...

just to let you know, i am using an MSAccess Database are you saying to use SELECT Parts_History.GroupID, Parts_History.PartNumber, Parts_History.PartDescription, Parts_History.Date_Out, Parts_History.Date_In, Parts_History.History, Parts_History.Log_Date FROM Parts_History ORDER BY...

Hi Ive tried varations on the following SELECT Parts_History.GroupID, Parts_History.PartNumber, Parts_History.PartDescription, Parts_History.Date_Out, Parts_History.Date_In, Parts_History.History, Parts_History.Log_Date FROM Parts_History ORDER BY Parts_History.GroupID ...

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