Query w/Indicator?

[Neo-fite]

I have the following Query Example...

SELECT  [Name], [Reason 1], [Reason 2], [Reason 3], [Reason 4], [Reason 5]
FROM [tblTest7] as Q
WHERE [Region]='Canada'
ORDER BY [Name], [Reason 1]

Is it possible to have another column that would contain an 'x' is any of the 5 Reasons start with 'Data'?

 

[plog]

Yes.

SELECT  [Name], [Reason 1], [Reason 2], [Reason 3], [Reason 4], [Reason 5], IIF([Reason 1] LIKE "Data*" OR [Reason 2] LIKE "Data*" OR [Reason 3] LIKE "Data*"  OR [Reason 4] LIKE "Data*"   OR [Reason 5] LIKE "Data*", "x") AS YourFieldNameHere
FROM [tblTest7] as Q
WHERE [Region]='Canada'
ORDER BY [Name], [Reason 1];

Replace 'YourFieldNameHere' with what you want to call this field.

 

[Neo-fite]

yes.

select  [name], [reason 1], [reason 2], [reason 3], [reason 4], [reason 5], iif([reason 1] like "data*" or [reason 2] like "data*" or [reason 3] like "data*"  or [reason 4] like "data*"   or [reason 5] like "data*", "x") as yourfieldnamehere
from [tbltest7] as q
where [region]='canada'
order by [name], [reason 1];

replace 'yourfieldnamehere' with what you want to call this field.

tyvm!!!