Hey thanks for your help by the way.

The problem I am having is the Date and Time are split into two different fields. If it was one DateTime field I...

I'm trying to convert something somebody wrote in Access to SQL (Hence the last). Here is the original query:

SELECT qryDLOnCall1st.Emp_Dist, qryDLOnCall1st.Emp_Dept, qryDLOnCall1st.Emp_ID, qryDLOnCall1st.FullName, qryDLOnCall1st.Emp_ClassName, qryDLOnCall1st.Emp_Phone1, qryDLOnCall1st.Emp_Phone2, Max(qryDLOnCall1st.MaxOfCallDate) AS MaxOfMaxOfCallDate, Last(tblCallOuts.CallTime)...

Hmmm, I don't just need one though, I need the last entry per each user ID.

Can I use Top on a per column basis e.g.:

(Top 1 MyColumn) as TopColumn?

Hmmm....I would...

OIC, thanks.

I can't use a Case statement in a View either?

Well I'm trying to convert this crazy nested Access mess somebody had written into SQL Server. So I should use Views instead of seperate StoredProcs?