Making a query

T

Thomas Woof

Hi
I need to make a query which will show all the people who are doing a
standard task. This i can do, however i need to exclude people from the
search. If one of the stages is 0 that needs to be excluded from the query
and will not be shown. How do i do it?

Thanks
 
J

Jason Lepack

You need to give examples of your tables, the SQL of your query that
you are currently using, sample data, and expected output before we
can really help you.

To get the SQL go to Query Designer, click View->SQL View, copy the
text that is there.

Cheers,
Jason Lepack
 
T

Thomas Woof

SELECT [Bankside 2006].Name, [Bankside 2006].Surname, [Bankside
2006].[Student ID], [Bankside 2006].[S/E]
FROM [Bankside 2006]
WHERE ((([Bankside 2006].[S/E])="standard"));

I want basically to have only the standard projects shown, but i want to
exclude those who have not completed project B. So if Project B is =0 i want
that thing of information excluded from the search.
 
J

Jason Lepack

Is [Project B] a field in [Bankside 2006]?

If so:
SELECT [Bankside 2006].Name, [Bankside 2006].Surname, [Bankside
2006].[Student ID], [Bankside 2006].[S/E]
FROM [Bankside 2006]
WHERE [Bankside 2006].[S/E]="standard" AND [Bankside 2006].[project
B]=0;
 
Top