Query that brings only one if "Flex Shift" selected

[Krefty]

As always thank you in advance for looking at my problem.
I have the below query that populates a standby report.
As I am sure those of you that are smarted than I can see
if standby status is "Service Standby" or "Supervisor
OnCall" it populates the report with Home, Cell, and
District Number, Last Name, First Name, is their anyway to
improve this to if [Standy Status] is "Flex Shift" SELECT
Flexphone from [Southern Employees]


SELECT OfficeLocation,[Standby
Status],LastName,FirstName,DstPgSpdDial,HmSpdDial,CellSpdDi
al
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")
UNION


Thanks in advance,
Krefty

 

[[MVP] S. Clark]

I would add the FlexPhone field to the list, and in the report, added logic
to only show the needed field, based on the Status. So, have the query
return all of the data, then let the report figure out what to show.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-