No Slash IF Question

[Guest]

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

 

[Rick B]

Why not add an if statement to your report to pull this data....

Iif([SomeTextBox]=" / ","",[SomeTextBox])


Rick B

 

[Roger Carlson]

Use the + concatenation operator instead of the &. Unfortunately, if you
just replace both apersands with plusses, if either field is NULL, NOTHING
will show, so I'd try this:

ControlSource =Trim([Equipment Nomenclature]&" " + "/" + & " " [Equipment
Name])

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Roger - When I use your below suggestion I get "The expression you entered
contains invalid syntax."

Any ideas???? - Pete

Use the + concatenation operator instead of the &. Unfortunately, if you
just replace both apersands with plusses, if either field is NULL, NOTHING
will show, so I'd try this:

ControlSource =Trim([Equipment Nomenclature]&" " + "/" + & " " [Equipment
Name])

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

 

[Roger Carlson]

Whups. Got them switched:

ControlSource =Trim([Equipment Nomenclature] & " " + "/" + " " & [Equipment
Name])

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Roger - When I use your below suggestion I get "The expression you entered
contains invalid syntax."

Any ideas???? - Pete

Use the + concatenation operator instead of the &. Unfortunately, if you
just replace both apersands with plusses, if either field is NULL, NOTHING
will show, so I'd try this:

ControlSource =Trim([Equipment Nomenclature]&" " + "/" + & " " [Equipment
Name])

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I'm using Access 97 and have a TextBox in a report which has the

following
as

its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the

report
if

either the Equipment Nomenclature or the Equipment Name controls are

NULL.
I

only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

 

[Guest]

Rick - Exactly where would I add your suggested if statement?? When I tried
to enter it as the ControlSource in the TextBox I had I got a Syntax Error
when I tried to open the report??
Again - Any help appreciated - Pete

Why not add an if statement to your report to pull this data....

Iif([SomeTextBox]=" / ","",[SomeTextBox])


Rick B

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

 

[Guest]

Roger - OK, no more Invalid Syntax, but I still get a "/" before Equipment
Name when Equipment Nomenclature is NULL. I don't want the "/" if either the
Equipment Nomenclature or the Equipment Name is null.

Any more suggestions - and thanks for your help in advance - Pete

Whups. Got them switched:

ControlSource =Trim([Equipment Nomenclature] & " " + "/" + " " & [Equipment
Name])

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Roger - When I use your below suggestion I get "The expression you entered
contains invalid syntax."

Any ideas???? - Pete

Use the + concatenation operator instead of the &. Unfortunately, if you
just replace both apersands with plusses, if either field is NULL, NOTHING
will show, so I'd try this:

ControlSource =Trim([Equipment Nomenclature]&" " + "/" + & " " [Equipment
Name])

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


I'm using Access 97 and have a TextBox in a report which has the following
as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report
if
either the Equipment Nomenclature or the Equipment Name controls are NULL.
I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

 

[Tom Lake]

Roger - OK, no more Invalid Syntax, but I still get a "/" before

Equipment
Name when Equipment Nomenclature is NULL. I don't want the "/" if either
the
Equipment Nomenclature or the Equipment Name is null.

Make the Control Source: =Iif(IsNull([Equipment Nomenclature]) or
IsNull([Equipment Name]), Trim([Equipment Nomenclature]&" "&[Equipment
Name]), [Equipment Nomenclature]&" / "&[Equipment Name])

Tom Lake

 

[fredg]

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

This works for me:

=([Equipment Nomenclature] + " / "+ [Equipment Name])

 

[Roger Carlson]

You're right! It would. That was my first thought, but I started second
guessing myself. Should have tested it. <sigh>

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

This works for me:

=([Equipment Nomenclature] + " / "+ [Equipment Name])

 

[Marshall Barton]

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

This works for me:

=([Equipment Nomenclature] + " / "+ [Equipment Name])

I don't see it Fred. The way I understand it, if either one
is Null, the result will be Null.

I was thinking of something along these lines:

=[Equipment Nomenclature] & IIf(([Equipment Nomenclature] +
[Equipment Name]) Is Null, "", " / ") & [Equipment Name]

 

[fredg]

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

Any help appreaciated - Pete

This works for me:

=([Equipment Nomenclature] + " / "+ [Equipment Name])

I don't see it Fred. The way I understand it, if either one
is Null, the result will be Null.

I was thinking of something along these lines:

=[Equipment Nomenclature] & IIf(([Equipment Nomenclature] +
[Equipment Name]) Is Null, "", " / ") & [Equipment Name]

Marsh,
Well, now you've got me wondering what he meant.
My take was that he didn't want anything if EITHER of the fields was
null.

 

[Marshall Barton]

I'm using Access 97 and have a TextBox in a report which has the following as
its ControlSource =[Equipment Nomenclature]&" / "&[Equipment Name].

Is there someway that I can prevent the "/" from appearing in the report if
either the Equipment Nomenclature or the Equipment Name controls are NULL. I
only want the "/" to appear if both controls are not NULL.

This works for me:
=([Equipment Nomenclature] + " / "+ [Equipment Name])

I don't see it Fred. The way I understand it, if either one
is Null, the result will be Null.

I was thinking of something along these lines:
=[Equipment Nomenclature] & IIf(([Equipment Nomenclature] +
[Equipment Name]) Is Null, "", " / ") & [Equipment Name]

Well, now you've got me wondering what he meant.
My take was that he didn't want anything if EITHER of the fields was
null.

Ok, Fred, that's what your expression does, but that's not
the way I read Pete's last sentence above ;-)

 

[Guest]

Tom - Thanks - It works perfectly. How do you guys learn this stuff??? I
have no background in writing this stuff. Again thanks - Pete

Roger - OK, no more Invalid Syntax, but I still get a "/" before
Equipment
Name when Equipment Nomenclature is NULL. I don't want the "/" if either
the
Equipment Nomenclature or the Equipment Name is null.

Make the Control Source: =Iif(IsNull([Equipment Nomenclature]) or
IsNull([Equipment Name]), Trim([Equipment Nomenclature]&" "&[Equipment
Name]), [Equipment Nomenclature]&" / "&[Equipment Name])

Tom Lake