Ok I want to run a SQL query while using the event procedure VB in MS Access.What I'm doing is trying to select a room of a building.So the form goes : Building (and they pick say Smith Hall) then ...

I've got a difficult problem (for me) that I'm hoping someone has an answer to. I've got two queries that I'd like to take values from, combine, and then return the values.Query 1:SELECT ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.