Skip to Content
0
Former Member
May 12, 2010 at 10:37 AM

Additional field in adhoc query

48 Views

Hi all, I need to be able to report on the IT105 subtype 0001 system ID for employees who are withdrawn from the company, however, when someone leaves their IT105 record is delimited so adhoc query will not output anything. Has anyone coded an additional field that will look at the latest record regardless of the date?

If you have, please can you share the code with me!?

Many thanks!