I have a data set with addresses, dates etc. Year built of properties is what im interested in. I also have a table with groupings/subsets in. I want to write a query that puts the 100's of locations into these subsets but I dont know what the best method is. I need them to be in groups of 10 year intervals.

Any help would be appreciated.

Many thanks