Use Alt-F9 to display the "underlying field code" of your field, which
should look something like

{ MERGEFIELD "InsolvencyDate" }

or

{ MERGEFIELD "InsolvencyDate" \*Mergeformat }

then type a "date format switch" into the field so that it looks like

{ MERGEFIELD "InsolvencyDate" \@"DD/MM/YYYY" }

or

{ MERGEFIELD "InsolvencyDate" \@"DD/MM/YYYY" \*Mergeformat }

Make sure you use upper case MM and not lower case mm (which means
"minutes")
Click Alt-F9 again

Select the MERGEFIELD field and press F9

Try the merge again.

If that doesn't fix the problem, you'll need to create a new query in Access
to return the right result. But let's see if that is necessary first.

Peter Jamieson