I was looking at the following article, and it looks as if it would solve my problem easily:
My scenario would be I have a table called Main, and each employee has a different User_ID where I simply want to show one of each User_ID in a query called Employee_Form. The biggest difference between their problem and mine is that I don't have a date range that I care about. I simply want one record shown for each User_ID. The code I've used is:
FROM Main AS s INNER JOIN [select Emp_ID from Main group by Emp_ID]. AS q
ON s.Emp_ID = q.Emp_ID;
Please forgive my ignorance on SQL, and if there is a better way, I'm open to suggestions, but the reason i'm going through this is because I had to link tables together and by doing so have multiple entries for the same information. Any thoughts would be greatly appreciated. Thanks.