K_ZEON's latest activity
-
KK_ZEON replied to the thread Solved Need help with Query.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...
-
KK_ZEON replied to the thread Solved Need help with Query.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...
-
KK_ZEON replied to the thread Solved Need help with Query.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...
-
KK_ZEON replied to the thread Solved Need help with Query.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...
-
KK_ZEON replied to the thread Solved Need help with Query.yes i tried group by but not able to get what i need.
-
KK_ZEON replied to the thread Solved Need help with Query.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...
-
KI have 2 tables tblJob & tblJobSession, pic attached I would like to show all Jobs with open jobsessions , but only the last visit so...
-
