ASP & SQL report

I'm new to ASP & wish to use it to create SQL report based on the following query:
SELECT DISTINCTROW Users.LastName, Users.FirstName, Users.JobTitle, Courses.CourseName, Status.Status, Status.Date FROM Users INNER JOIN (Courses INNER JOIN Status ON Courses.CourseID = Status.CourseID) ON Users.LoginName = Status.LoginName WHERE (((Status.Option)="Required")) ORDER BY Users.LastName;

Do I need to break up the SQL query per row and write out the report? I was thinking I could create this query, retrieve the information & create an SQL report. However, my SQL is very rusty so I don't remember how to make the command (the only nice thing about GUI interfaces, the client thinks I know how to make the report as I can print it from the db.)

Pointers would be appreciated.

You can try putting that in as your query and run it, one of two things will happen,
either it works or you'll get syntax errors.

If you have created the report in a GUI, you should have the option to view the SQL from the GUI, then cut and paste.

Your other option would be to try some of the websites out there, i.e. www.devguru.com