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

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