In an access database I need to run a SELECT but need some pointers –
It needs a IF *building = *Main or *New or *Six
THEN list *roomnames that are relevant to *building (RoomName is Identified by M01 (Main) N01 (New) and S01 (Six))
I have created the building table and the room table but fail at the hard stuff! :p I assume you can narrow it down by the prefix?
It needs to remove any rooms not in the building chosen in the previous dropdown field
Can you help?