Thanks everyone, I eventually managed to solve it and will stick the code up sometime soon, Hopefully it will be acceptable 😀

Thanks, so the idea is to build a tally table on the fly and select from that for my query is that correct?

Ok, That helps a little, I thought I would be able to figure out the rest but alas, what I need is a counter to add the integers until we...

Yes, thanks guys! its worked 🙂 I am not sure why, but that is how I have been instructed to calculate it, instead of the individual audit I am to...

@ JEff, When grouping we have to add every column that is not part of an aggregate function to the group by clause, this then alters the results accordingly, (learnt...

Thanks guys, It turns out my db design was the problem so it overly complicated the querying process! What I needed was to select some aggregated values, and some contact...

Evil Kraig, yes that is simmilar to what Im looking for!!

Unfortunately its not as simple as the wrong data as suggested by the 2nd poster!

I seem to have overcome my initial issue but come up to another dead end (so to say) and cant make out what your query is doing exactly, I...

@AndyHyslop Thanks that is almost what I am after, customers who have not bought products b and c however I only want results from these customers (who haven't bought b...

I am trying to say give me all customer numbers and their total purchases SUM() for those customers who have bought product b and any other products besides c and...

ignore the syntax above, I did include the FROM in the subquery

That was the first thing I thought of, problem with that is it also gives me the customers who have not bought the products in the IN() part of...

Yes that is correct, It seems that using IN() will do the trick!

To find a customer that has purchased one product and not another can I use somthing like this?

SELECT...

Thank you!!:-D