Go to window and make sure bindings or database of one of those is checked. Then click on Bindings or Server Bahaviors and click Recordset. Then name the connection and click define. You can either use DSN or map to the database. DSN is easy because you type in the name of the DSN you created on the server. Mapping is easy too... you enter something like this (depends on where your database if)...
"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\database\database.mdb")
Then click done and you should be able to finish the recordset with the filtering and ordering that you want. You can switch to advanced if you need to create more query options.
Hope this helps.
BTW, go to bindings to see the fields you need and you can simply drag them where you want them. You can also use the Dynamic Text if you want and it gives you some better formatting abilities.
Linear Mode
