Expressions in a report

[Grace from Iowa]

I am trying to get my repeort to show Practice Name and if it is null to
print address 1. what expression do I need to write to accomplish this.
thanks Grace

 

[fredg]

I am trying to get my repeort to show Practice Name and if it is null to
print address 1. what expression do I need to write to accomplish this.
thanks Grace

Using an unbound control:
=IIf(IsNull([Practice Name]),[Address1],[Practice Name])

 

[Grace from Iowa]

It is a bound control. I need my report to show the Practice Name and if the
Practice name is null then I need it to Address 1. Sorry I may have not be
clear enough. Thanks so much for your help/

I am trying to get my repeort to show Practice Name and if it is null to
print address 1. what expression do I need to write to accomplish this.
thanks Grace

Using an unbound control:
=IIf(IsNull([Practice Name]),[Address1],[Practice Name])

 

[John Spencer]

You need to add an unbound control to your report and then set its
source to one of the following.

=IIf(IsNull([Practice Name]),[Address1],[Practice Name])

or

= NZ([Practice Name],[Address 1])



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

It is a bound control. I need my report to show the Practice Name and if the
Practice name is null then I need it to Address 1. Sorry I may have not be
clear enough. Thanks so much for your help/

I am trying to get my repeort to show Practice Name and if it is null to
print address 1. what expression do I need to write to accomplish this.
thanks Grace

Using an unbound control:
=IIf(IsNull([Practice Name]),[Address1],[Practice Name])

 

[fredg]

It is a bound control. I need my report to show the Practice Name and if the
Practice name is null then I need it to Address 1. Sorry I may have not be
clear enough. Thanks so much for your help/

I am trying to get my repeort to show Practice Name and if it is null to
print address 1. what expression do I need to write to accomplish this.
thanks Grace

Using an unbound control:
=IIf(IsNull([Practice Name]),[Address1],[Practice Name])

Yes, I understand [Practice Name] is a bound control.
You MUST use an unbound control in the report to do what you wish to
do. Just drag a new unbound control where you wish to show the data.
Set it's control source to what I suggested.

 

[Grace from Iowa]

Hi when i use this formula =IIf(IsNull([Practice Name]),[Address1],[Practice
Name]) it ask me to enter a para,eter value? what is up with that.

It is a bound control. I need my report to show the Practice Name and if the
Practice name is null then I need it to Address 1. Sorry I may have not be
clear enough. Thanks so much for your help/

On Mon, 12 May 2008 12:50:00 -0700, Grace from Iowa wrote:

I am trying to get my repeort to show Practice Name and if it is null to
print address 1. what expression do I need to write to accomplish this.
thanks Grace

Using an unbound control:
=IIf(IsNull([Practice Name]),[Address1],[Practice Name])

Yes, I understand [Practice Name] is a bound control.
You MUST use an unbound control in the report to do what you wish to
do. Just drag a new unbound control where you wish to show the data.
Set it's control source to what I suggested.

 

[fredg]

Hi when i use this formula =IIf(IsNull([Practice Name]),[Address1],[Practice
Name]) it ask me to enter a para,eter value? what is up with that.

It is a bound control. I need my report to show the Practice Name and if the
Practice name is null then I need it to Address 1. Sorry I may have not be
clear enough. Thanks so much for your help/

:

On Mon, 12 May 2008 12:50:00 -0700, Grace from Iowa wrote:

I am trying to get my repeort to show Practice Name and if it is null to
print address 1. what expression do I need to write to accomplish this.
thanks Grace

Using an unbound control:
=IIf(IsNull([Practice Name]),[Address1],[Practice Name])

Yes, I understand [Practice Name] is a bound control.
You MUST use an unbound control in the report to do what you wish to
do. Just drag a new unbound control where you wish to show the data.
Set it's control source to what I suggested.

If it is asking you fro a parameter, what parameter is it asking for?
Practice Name? Address1? Something else?

I would suspect you have miss-spelled one of the field names, i.e.
[Practice Name] is not the same as [PracticeName].

Also, make sure the name of this control is not the same as the name
of any of the fields used in the expression.