Yes. This is what I get:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'letter' in expression. /wheelofgod/letters.asp, line 18
letters is an "include" asp file. The purpose of this is to match the column of table 1 with the column of table 2 because table 2 has url links for each record. Thus by clicking on the link I should get different url depending what the number is.
Example I have "book_spoke" from table 1 which has a value of '15'. It should match with the "book_spoke" from table 2 which has the same value. (which one has to be primary key?). So table 2 has a url for each "book_spoke" value.
RS is supposed to be the recordset for the first sql. Letter is supposed to be the recordset for the second. I don't know if it makes sense. The second sql is for the second table.