Thanks Nick

Appreciate the field naming point - more inexperience with Access than
anything else.

Have recreated the query and have gone with Dick's refresh option,
which seems to be working.

Still find it frustrating though, that one minute it was working, the
next it wasn't. It's the sort of thing that will bug me even though I
seem to have an alternative.

Again, thanks for the reply

Gary