Thanks for confirming Lynn.

Highest prod I’d.

Thanks Luis, that makes sense.

I will look at the book and I get that.
But I am still using the function.
Before - the  function was being called from a view.
After -...

Thanks both it worked, I had to change the join on employee rather than prod.

I just put a criteria for an inv_id. And it is including all employees in the result.

I just check for inv_id 104 and it gives me all employees.

It does not seem to find the missing rows in my real data. 

As for the design, this is what I have inherited so that's what it is.

Thanks for confirming what I was thinking. Then is there a way that I can force the order? 
ORDER BY would not work given the names but is there a...

Thanks that worked.

Would be nice if I could land first:-(

I fully understand, but the person/s who created these files did not nad i have zero chance of making them redo anything. So I just have to live with it.:-(

I tried that but some fields were getting split at commas in cell value.

Can't have that happen.

The goal is to get the data in somehow and then I can...

It takes out some of that stuff and puts the data in neaty columns, I looked at csv files nad noticed that it was splitting columns at commas in the...