Query parameters.

  • Thread starter Thread starter Paul Amodio
  • Start date Start date
P

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!
 
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
 
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
 
Back
Top