I have converted access 97 to access xp adp project and connect the
table from my sql server 2000. my problem is that when i run my report
it says "Invalid SQL Statement. Check the server filter on the form
recordsource"

here's what the error says:

Error in list of function arguments: '=' not recognized.
Error in WHERE clause near '!'.
Unable to parse query text.

here's my sql statement:

SELECT     Students.IDNo, [LastName] + ', ' + [FirstName] + ' ' +
[MiddleName] AS Name, Students.Address, Students.PlaceofBirth,
Students.DateofBirth,
                     Students.[ParentGuardian], Students.ElemSchool,
Students.ESAddress, Students.ESSchYear, Students.SecSchool,
Students.SSAddress,
                     Students.SSSchYear, Program.ProgramTitle,
Program.ProgramDesc, IIf([ProgramTitle] = 'BEED', 'with concentration
in ' + [Major], [Major])
                     AS MajorTemp, [Sem] + ' Semester, ' + [SchYr] AS
SchYrSem, Course.CourseCode, Course.CourseTitle,
SchYrSemCourseJoin.Final, Course.Unit,
                     Students.IDNo, SchYrSem.SchYrSemID,
SchYrSemCourseJoin.Annotation
FROM         (Program INNER JOIN
                     Students ON Program.ProgramID =
Students.ProgramID) INNER JOIN
                     ((Major INNER JOIN
                     SchYrSem ON Major.MajorID = SchYrSem.MajorID)
INNER JOIN
                     (Course INNER JOIN
                     SchYrSemCourseJoin ON Course.CourseID =
SchYrSemCourseJoin.CourseID) ON SchYrSem.SchYrSemID =
SchYrSemCourseJoin.SchYrSemID) ON
                     Students.IDNo = SchYrSem.IDNo
WHERE     ((([LastName] + ', ' + [FirstName] + ' ' + [MiddleName]) =
[Forms] ! [Transcript of Records Dialog] ! [txtName]));

thanks in advance for any help.