I have literally just searched for how to do it via a query so am battling this now.
Now I have to clear out the cobwebs to work out using the dateadd without getdate and for the field haha! Friday afternoon fun.
Thanks for the help, good to know I finally got on the right track.