Search results

HI, I'm trying to find the sum of inspections per inspector and area. Each inspector works either alone or in a team of 2. I have a table with the fields Inspector_1 and Inspector_2. I've written 2 queries that give me the correct sums by inspector and area (one for each field above). The...

HI although I've been working with MS Access for years, I've only just found this forum. Lots of great info in here. This is my first post and yes I have used the search function but couldn't find an answer that worked. What I need to do is count unique sets of data. I have a table with about...