Sadly no this is totally different, I think I may have to go back to the drawing board.

What I wanted to do was.... there is a TABLE called 'PickfaceMaster', these are locations that needed counting every 3 months.

I setup a query called 'Outstanding Pickface Selection' using 'Find Unmatched Query Wizard. which basically cross matches 'PickfaceMaster' with 'PickfaceCounts' and gives me a 'NULL' report which I can select from and a separate report/table shows the details.

This all works great until all pickfaces are counted !!!!!

I think that probably the best way for this to work is going to have to be export the data from 'PickfaceCounts' table to either another table or excel and then wipe the data from 'PickfaceCounts'