I don't know what I am doing wronge, I have this in the RECORD SOURCE area
for a form:

Subjects: Concatenate2("SELECT Format(Last,'>')&', '& [first]&' '&[middle]&'
[DOB/'&format([dob],'mm-dd-yyyy')&']' FROM tblPerson INNER JOIN (tblOperation
INNER JOIN tblOperation2Person ON tblOperation.OperationID =
tblOperation2Person.OperationID) ON tblPerson.PersonID =
tblOperation2Person.PersonID WHERE tblOperation.OperationID=" & [OperationID])

It creates a field called Subjects that I list all the people's names and
DOB's...  I want this sorted by, Last Name, First Name, Middle Name, and then
DOB.  I tried putting ORDER BY at the end and it is not working.

Where does this go or how to I get it to sort in this way?

Thanks!