Why do you need 4 separate SQL statements? If each one of them pulls data from different tables, then you need to join all the tables based upon their keys. You should only need one (and potentially more sub-queries). Can you give us an example of what the 4 SQL statements are?
okay I have 1 table called courses with around 20 columns. each course can appear in 4 categories. so i need to go through searching the database 4 times each time on a different category. Therefore needing the four sql statements. then when inserted into the recordset, i can sort the courses by category.
...is there also maybe a way i can do this with a UNION? although i would like to know for future reference if its possible to combine several SQL statments in one recordset.