I am trying to list all staff in each department. I am using access, and have defined a link key so that the tables are joined. I followed your original instructions in defining the query, getting the SQL statement that access defined for the query, and pasting it into the asp script. Well, no matter what I try, it will not work. I continually get errors.

the script is as follows:

<HTML>
<BODY>
<CENTER>
Welcome to an ASP-db™ Test Page.<P>
<%
Set MyDb = Server.CreateObject(&#34;ASPdb.Free&#34 &#39; Create the ASP-db™ object
MyDb.dbMDB = Server.MapPath(&#34;DepartmentsNew2000.mdb&#34 &#39; Use YourFile.mdb in the current directory
MyDb.dbColor = &#34;1,auto&#34; &#39; Pick color scheme 1, turn on Color button
MyDb.dbMode = &#34;grid&#34; &#39; Show it in &#34;display&#34; mode
MyDb.dbGridTableTag = &#34;BORDER=2&#34; &#39; Set the table BORDER to 2
MyDb.dbSQL = &#34;SELECT DepartmentInfo.DepartmentName, WSCStaff.Fname, WSCStaff.Lname, WSCStaff.Title, WSCStaff.Extension, WSCStaff.Email&#34; &_
&#34;FROM DepartmentInfo, WSCStaff INNER JOIN Staff_Dept ON WSCStaff.ID = Staff_Dept.ID&#34; &_
&#34;ORDER BY DepartmentInfo.DepartmentName, WSCStaff.Lname&#34;
MyDb.ASPdbFree &#39; Tell ASP-db to show the table
%>
</CENTER>
</BODY>
</HTML>

I have tried to move the quotes and seperate the statements in different ways, i have tried to add &_ at the end of the statements like the example on your web site and I am at a loss.

Could someone please help.

Thank you
Jennifer C. Swartz