Combining data

[laxster]

I ended up talking to people to determine why we have 2 coordinators for some jobs, and it appears we don't actually need 2 coordinators per job, this means someone made a data entry error.

However, I still do have an issue with duplicates in the Kitting query, even though the SQL has the SELECT DISTINCT built into it. Should I provide a sample again?

 

[Scooterbug]

Providing a sample would be good. Makes things a bit easier

As for the DISTINCT, you have to remember that when you use that, it counts towards ALL the fields that you have in the query. So, for example, if you have a query that list all of your products. You include both the name and the price in the query. If you have rows where the productname is the same and the price is different, then you will see the Product Name show up twice.