Search results

durp, thank you so much. I have been working on this for too long and I think I was having a brain melt.

I followed the steps in this thread and it worked well, except the numbering is in the opposite order of what I would like. The oldest date I would like the numbering to start at 1, then 2 etc. Based on duplicate EE ID #s. I have tried sorting it in the org query by EE# then date oldest to...

Thank you so much! That worked perfectly. Not sure why it stopped working or why this was the only division that had issues (the other 3 are set up the same and flow correctly) other than we upgraded to Win10. I appreciate everyone's help!

I can post the photos. would that be sufficient? Transfer table is the one where it assigns the 1 if inter-division or "" if not Transfer 2 png is showing the example person who is not in the result of the query link query is taking the hr query and joining to the transfer table link table...

Hi, I have a query that I run that produces a list of employees that are transfers. If they have transferred inter-division it assigns a 1 if not an inter-division transfer a blank or they do not show up in the query if they were not a transfer. My HR query outer joins to the transfer query...