Need help....

How do I combine the following two statements? I'm using them in ASP connected to Access DB.

SqlJunk = " SELECT SUM(MSD+Methods+Analysis+Architectures+Models+Stud io+Elective1+Elective2+Elective3) As PersonTotals FROM tblpersons "
SqlJunk = SqlJunk & " WHERE User_Id=" & Request.Form("DaInBox")

SqlJunk = "SELECT FirstName, LastName, WeekNo, ProgramName, StudioTeamName FROM tblpersons"
SqlJunk = SqlJunk & " WHERE User_Id=" & Request.Form("DaInBox")

Thanx

I'm not sure what you're trying to do but here's one method:

SqlJunk = " SELECT FirstName, LastName, WeekNo, ProgramName, StudioTeamName,
SUM(MSD + Methods + Analysis + Architectures + Models + Studio + Elective1 + Elective2 + Elective3) As PersonTotals FROM tblpersons "
SqlJunk = SqlJunk & " WHERE User_Id=" & Request.Form("DaInBox")
SqlJunk = SqlJunk & " GROUP BY FirstName, LastName, WeekNo, ProgramName, StudioTeamName"