Thanks that makes much more sense than all the examples i have found. Will give it a go.

Cheers

Armo

yes, its just a basic sellect all query.

Im not 100% sure what you mean and how to go about it?

Thanks for your time, i can create the numbers table using your code, however im not sure about creating an insert loop. As you may have worked out im new to SQL.

This is for an ordering system, i want the user to be able to create a list of stock ordered. However, each individual unit will be allocated an individual StockID and...

Thanks again, it all starts to make sense when i see the correct syntax

Hi Nivedita

Yes please,

I thought it was to do with case and else end, but am having difficulty putting the sql together.

Niall

Thank you very very much, i have been struggling with that all day. I was starting to think i should pack it all in and become a labourer. You have...