Hi Nigel,

Glad I was able to help. The HasData is not something I have used in
the past. Good to know about it! Thanks for posting your solution!

Clifford Bass

Nigel wrote:
Hi Clifford

No, that didn't work either. But, I've managed to find a solution:

IIf([HasData],Count(*),"No Data")

Many thanks for your replies and help.

Nigel

--
Message posted via http://www.accessmonster.com