Pulling from Table won't work.

[Krefty]

Good day and thanks for looking at my problem. I have
created the following Querie that works for one thing but
I can't remember what to do or see what is missing to make
this work.

I have the following querie:

SELECT OfficeLocation,[Standby
Status],LastName,FirstName,"Special Instructions"
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

I need the "Special Instructions" data to populate the/a
cell that has any data that also meets the criteria of
Standby Status. Last Name, First Name and Standby Status
all work fine, but it does not pull in the data from the
table listed under special instructions.

Can you assist me in helping me see what I forgot to do or
need to add.

Thanks,
Krefty

 

[Gerald Stanley]

Try
SELECT OfficeLocation,[Standby
Status],LastName,FirstName,[Special Instructions]
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

Hope This Helps
Gerald Stanley MCSD

 

[Krefty]

Thanks but when I try this it returns a syntax error. Any
additional ideas?

\

-----Original Message-----
Try
SELECT OfficeLocation,[Standby
Status],LastName,FirstName,[Special Instructions]
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Good day and thanks for looking at my problem. I have
created the following Querie that works for one thing but
I can't remember what to do or see what is missing to make
this work.

I have the following querie:

SELECT OfficeLocation,[Standby
Status],LastName,FirstName,"Special Instructions"
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

I need the "Special Instructions" data to populate the/a
cell that has any data that also meets the criteria of
Standby Status. Last Name, First Name and Standby Status
all work fine, but it does not pull in the data from the
table listed under special instructions.

Can you assist me in helping me see what I forgot to do or
need to add.

Thanks,
Krefty
.

.

 

[Gerald Stanley]

Make sure that there is a space between the end ] and the
word FROM and again between ] and WHERE.

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Thanks but when I try this it returns a syntax error. Any
additional ideas?

\

-----Original Message-----
Try
SELECT OfficeLocation,[Standby
Status],LastName,FirstName,[Special Instructions]
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Good day and thanks for looking at my problem. I have
created the following Querie that works for one thing but
I can't remember what to do or see what is missing to make
this work.

I have the following querie:

SELECT OfficeLocation,[Standby
Status],LastName,FirstName,"Special Instructions"
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

I need the "Special Instructions" data to populate the/a
cell that has any data that also meets the criteria of
Standby Status. Last Name, First Name and Standby Status
all work fine, but it does not pull in the data from the
table listed under special instructions.

Can you assist me in helping me see what I forgot to do or
need to add.

Thanks,
Krefty
.

.

.

 

[Krefty]

Nope...didn't work?

-----Original Message-----
Make sure that there is a space between the end ] and the
word FROM and again between ] and WHERE.

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Thanks but when I try this it returns a syntax error. Any
additional ideas?

\

-----Original Message-----
Try
SELECT OfficeLocation,[Standby
Status],LastName,FirstName,[Special Instructions]
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Good day and thanks for looking at my problem. I have
created the following Querie that works for one thing but
I can't remember what to do or see what is missing to make
this work.

I have the following querie:

SELECT OfficeLocation,[Standby
Status],LastName,FirstName,"Special Instructions"
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

I need the "Special Instructions" data to populate the/a
cell that has any data that also meets the criteria of
Standby Status. Last Name, First Name and Standby Status
all work fine, but it does not pull in the data from the
table listed under special instructions.

Can you assist me in helping me see what I forgot to

do
or

need to add.

Thanks,
Krefty
.

.

.

.

 

[Gerald Stanley]

Try replacing the " with ' in the In clause. Failing that,
start with a new Query in Design View and use drag and drop
to pick up the columns then type in the criteria.

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Nope...didn't work?

-----Original Message-----
Make sure that there is a space between the end ] and the
word FROM and again between ] and WHERE.

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Thanks but when I try this it returns a syntax error. Any
additional ideas?

\
-----Original Message-----
Try
SELECT OfficeLocation,[Standby
Status],LastName,FirstName,[Special Instructions]
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Good day and thanks for looking at my problem. I have
created the following Querie that works for one thing
but
I can't remember what to do or see what is missing to
make
this work.

I have the following querie:

SELECT OfficeLocation,[Standby
Status],LastName,FirstName,"Special Instructions"
FROM [Southern Employees]
WHERE [Standby Status] In ("Service
Standby", "Supervisor
OnCall")

I need the "Special Instructions" data to populate the/a
cell that has any data that also meets the criteria of
Standby Status. Last Name, First Name and Standby
Status
all work fine, but it does not pull in the data from the
table listed under special instructions.

Can you assist me in helping me see what I forgot to do
or
need to add.

Thanks,
Krefty
.

.

.

.

.