Thanks Mark
A great thank you guys i think im beginning to see the light now.
Yes you are right philmorris i can only see the front end which appears limited.
You make it sound easy 
i will try and follow your advice and i know it will be a bumpy ride but i think i would have learnt a lot when this is done.
So am i right to assume once i decide on the objects and design my report i then save this and use the SQL behind it?
philmorris is this what you were referring to:
I have SQL Server 2008 so good
Toon (BOB member since 2012-05-24)