Recent content by MDavidCrompton

Nope, that also refers to the value of an existing field but I can think of a few other uses for it, thanks. Is there a way of counting the number of available fields in a report or the number of columns in a query. The crosstab will deliver one extra column per extra floor which in turn...

Hi, Tried isnull but that refers to current record. Never heard of "nz". I'm off to try it right now

Hi, Thanks but I really don't want to mess with the crosstab. I just want a way of setting a control on a report to something like: iif [Floor3] exists [Floor3] Else "" Cheers David

Hi, New member in the last few moments. The M stands for Michael which is my first name but I have always been called David. UK resident, freelance developer and trainer in Access and Excel. Reasonably advanced in some respects but always being tripped up by simple things I have forgotten or...