Recent content by Riordan

Sorry that doesn't work - it now prompts for the payroll number which it should be picking up from the amendments history file.

Hi, I have a table which lists amendments (amendments history file) which need to take effect of another table (M0070), I can select the records fine and so the sub query looks to be okay but I'm missing something (probably obvious) in the deletion query where by it does only delete the records...