thank you so much for your replies. As soon as I sent this post I figured it out. Once again, thanks for all your help on this.

Thanks to everyone who helped me with this issue. I have it working and now I have another problem.....

I am trying to write a query for a report that...

yeah, I guess Access limits you what you can do. Actually I did start out using the query design but nothing would work that way. But the code...

SELECT dbo_tbl_Files.FileID, dbo_tbl_Files.SectID, dbo_tbl_Files.AttyID, (RTrim(Attorney.LName) & ', ' & RTrim(Attorney.FName)) as Attorney, (RTrim(Secretary.LName) & ', ' & RTrim(Secretary.FName)) As Secretary, dbo_tbl_Files.FileNo, dbo_tbl_Files.FileName, dbo_tbl_Files.Dept, dbo_tbl_Files.DateOpened, dbo_tbl_Files.Description, dbo_tbl_Files.Status

FROM dbo_tbl_Files

INNER JOIN dbo_tbl_Employees As...

Thanks that worked but for some reason it's bringing in each record twice.