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

Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats. There is no connection type specific to Microsoft SQL ...

I've got a difficult problem (for me) that I'm hoping someone has an answer to. <BR><BR>I've got two queries that I'd like to take values from, combine, and then ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...