RowSource Sort 1

[Elvis72]

I have the following Select Statement in my RowSource for a Subform:

SELECT [TitleID], [Position Title] AS FullName FROM TblStaffRequirements;

I need to sort by Position Title, and I'm not sure how to achieve that?

Thanks so much for your time!~

 

[PHV]

SELECT [TitleID], [Position Title] AS FullName FROM TblStaffRequirements ORDER BY 2;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886