neileg, many thanks, however its still displaying the gaps!
I have had a another look at the query that I am doing, I have
Toolid | Make | Model | Lasttestdate |
in the Lasttestdate i have <=DateAdd("m",-3,Date())
the tools get tested on a regular basis, so it is pulling the previous...