Search results

HI First, thank you for your help. In my defense, although I've been working with Access for 10 years, now, almost everything I know I learned by pressing F1. I've designed a couple of DB where I did actually follow that type of structure. In this case however, the raw data are coming from...

Thanks. That works perfectly. I've never worked with union queries before so this was new to me. I know using spaces and German letters is wrong and a bad habit I should break. In this case the names come from a lotus DB export and I was too lazy to change them. I can't separate the data into...

Thanks to the help above I've managed to solve the first issue but now I've found a second problem. To get the total number of inspections per inspector I have a query which sums 2 other queries: First the number of inspections for each inspector is counted where he is inspector #1 and there is...

HI, Thanks for the help. Left outer join is a step in the right direction. Now the missing inspectors are included but the QA Area and the sum of SKU_Count are empty. Cheers DB

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...

Not sure what I did wrong the first time but after completely re-writing the code it works perfectly. Thanks for your help. Cheers DB

Thanks for the suggestion but this is exactly the problem I'm having. I can't get the query to distinguish unique rows because I can't get the query to compare multiple fields. Cheers DB

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...