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 ...

My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to run ...

You don’t need an expertise in SQL to limit the number of records in a group. With your user knowledge of queries and reports, you have all the expertise you need. Grouping records in Access is easy, ...