Search results

Yup training / PEBKAC issue , considering i've had some of the users / techs phone me up late at night asking how to turn off their laptop the level of competency is pretty low and even the hit them with a big stick approach doesn't work too well! ;) the third query does the trick in giving me...

Problem solved! :) made a third query which pulls in the results from the second. in this query have grouped the person_index and selected LAST on all the other fields. Gives me 1 row per person! That should do the trick , thanks guys for your help!

At the moment no it doesn't as the user can enter that date the report was created rather than it being automatically created. (these are offsite reports so sometimes the user enters them into the system 2 or 3 days after they have actually carried out the work that needs to be recorded.) it...

Hi, report_number is a unique field with a number for the report that the user has written. A text field. What i am trying to do is identify the last report each user has created not a count of the number of reports. So i need to group the users and get the max date, but problem comes up...

Hi Alan, That works great thanks but with one small issue. If the employee has more than one report on that day it gives multiple rows for that employee in the second query. only way i can think of is to have time and date in the field to seperate them out but the users manually enter the...

Morning all , Bit stumped and not sure if this is actually possible. I have a table which holds details of reports created by different people. I want to display the last report created by each person so.... I've "group By" 'd the person_index and used Max to get the last date of their...