Query parameters.

[Paul Amodio]

I'm trying to figure out how to display the data in a
certain cell based on wether another cell has data in it
or not.

In other words if cell 'B' is empty show the contents of
cell 'A'.

Please help. I've been all over this knowledge base.

Thanks!

 

[Michel Walsh]

Hi,

Nz(b, a)

Nz( b, a), as tell in the help file, return b, unless it is null, then it
returns a.


Sure, since you try to assign it to Me.b, it may be possible that Access
find it is recursive and won't like it at all (I didn't try for that
specific scenario).



Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

Hi,

Nz(b, a)

Nz( b, a), as tell in the help file, return b, unless it is null, then it
returns a.


Sure, since you try to assign it to Me.b, it may be possible that Access
find it is recursive and won't like it at all (I didn't try for that
specific scenario).



Hoping it may help,
Vanderghast, Access MVP