Creating a query to display a weeks records

[shabbaranks]

I did have 06 but I think I may have deleted it when I was removing the sensative data. Thank you soo much for all your help and your db example, I did actually get it sorted by converting the date format from within the VBA from Format() to DateValue() and this did the trick.

What I have told myself is to read over your examples properly to understand whats going on as I think this will help me in the future - thanks

[jzwp11]

You're welcome!