I then want to choose the first instance only or the most recent by date.
I researched where you can use First (1) [Completion Date]
However when I run the above named code I keep getting garbage after error when I include the Order By statement. When I exclude the Order By Statement, no problems. Ultimatley I wish to get the top 1 record based on the Completion Date. Any ideas here??