Hi,
I am producing a database in MS Access - which I can subsequently export into Excel if required - listing works to be carried out to many different properties. What I am hoping to do is highlight all of the addresses that amongst their many work items have had two or more specific items carried out, e.g. some properties may get new windows, some may get new doors but I would like to filter out all of the properties who get both new doors AND new windows but excluding those who only get one or the other. Is there a way to do this either in Access (or Excel as I can always import the table into there if it is easier)?
Any help would be greatly appreciated, Thanks.
Bookmarks