Merging Two Fields

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I am trying to get a Query to merge two fields into one if
the second field is not null.

In the SQL View for Select Query I have:

SELECT IIF([Comments From Meetings].[Decision Status] Is
Null,[Project Log].[Status],[Comments From Meetings].
[Decision Status][Project Log].[Status]) AS Expr2

The problem is that I don't know what goes between
[Decision Status] and [Status].

I want the results to look like this:

"Proceed - Estimate"
(which is a Decision Status) - (which is a Status)

Should I even be using an IIF function?

Thanks,

Jennifer
 
Hi,



SELECT field1 & field2 ...
or


SELECT field1 & ( ", " + field2) ...


if you wish a coma delimiting the two values ( I assume they are both
strings).



Hoping it may help,
Vanderghast, Access MVP
 
Thanks Michel.

You've been a real help.

-----Original Message-----
Hi,



SELECT field1 & field2 ...
or


SELECT field1 & ( ", " + field2) ...


if you wish a coma delimiting the two values ( I assume they are both
strings).



Hoping it may help,
Vanderghast, Access MVP


I am trying to get a Query to merge two fields into one if
the second field is not null.

In the SQL View for Select Query I have:

SELECT IIF([Comments From Meetings].[Decision Status] Is
Null,[Project Log].[Status],[Comments From Meetings].
[Decision Status][Project Log].[Status]) AS Expr2

The problem is that I don't know what goes between
[Decision Status] and [Status].

I want the results to look like this:

"Proceed - Estimate"
(which is a Decision Status) - (which is a Status)

Should I even be using an IIF function?

Thanks,

Jennifer
Click to expand...


.
Click to expand...
 
Back
Top