I have over a 100 sites that I want to create 4 groups and based on siteid. So the siteid will belong to one of 4 groups. I want to create a formula so I do not have to create groups in specified order but instead by a formula.
HELP! I normally don't write code or develop databases but I am trying to build a MS access database. I have one table (departments) with a list of departments and one table (112) with department, question text and question answer columns. I am trying to build a form where user selects department...