Expression

[Guest]

Hi,

I am trying to recreate a query using the same tables and one of the
expressions is this: Salutation: IIf([company]=([FirstName] & " " &
[LastName])," ",[Salutation1])

What I can't figure out is why it will not display in the new query. The
tables are the same. Any idea?

 

[Guest]

The expression isn't clear to me. Why would you want a company to equal a
first and last name? Can you clarify?

 

[Guest]

Sometimes a company is a Sole Proprietorship and the name of the company is
the name of the owner of the company like John Smith.

The expression isn't clear to me. Why would you want a company to equal a
first and last name? Can you clarify?

--

The 11th day of every month:

http://truthaction.org/forum/index.php

Hi,

I am trying to recreate a query using the same tables and one of the
expressions is this: Salutation: IIf([company]=([FirstName] & " " &
[LastName])," ",[Salutation1])

What I can't figure out is why it will not display in the new query. The
tables are the same. Any idea?

 

[Guest]

If the expression true then you are evaluating it to give a space (" ").
Swap them:

IIf([company]=([FirstName] & " " & [LastName]),[Salutation1]," ")



--

The 11th day of every month:

http://truthaction.org/forum/index.php

Sometimes a company is a Sole Proprietorship and the name of the company is
the name of the owner of the company like John Smith.

The expression isn't clear to me. Why would you want a company to equal a
first and last name? Can you clarify?

--

The 11th day of every month:

http://truthaction.org/forum/index.php

Hi,

I am trying to recreate a query using the same tables and one of the
expressions is this: Salutation: IIf([company]=([FirstName] & " " &
[LastName])," ",[Salutation1])

What I can't figure out is why it will not display in the new query. The
tables are the same. Any idea?

 

[Guest]

I found out something weird and now it is being displayed. I was taking last
years query and altering it with 07 in place of 06 where appropriate. This
wasn't the only field that wasn't being displayed. The only thing I can
figure is that Access did not like the fact that I was not starting fresh.
When I built the query from scratch it works fine. Go figure? Thanks for your
help.

If the expression true then you are evaluating it to give a space (" ").
Swap them:

IIf([company]=([FirstName] & " " & [LastName]),[Salutation1]," ")



--

The 11th day of every month:

http://truthaction.org/forum/index.php

Sometimes a company is a Sole Proprietorship and the name of the company is
the name of the owner of the company like John Smith.

The expression isn't clear to me. Why would you want a company to equal a
first and last name? Can you clarify?

--

The 11th day of every month:

http://truthaction.org/forum/index.php


:

Hi,

I am trying to recreate a query using the same tables and one of the
expressions is this: Salutation: IIf([company]=([FirstName] & " " &
[LastName])," ",[Salutation1])

What I can't figure out is why it will not display in the new query. The
tables are the same. Any idea?