Filtering (1 Viewer)

[mtagliaferri]

Hi have a query that works fine when I have to select one parameter, however I don't know how to select multi parameters...
In this query I would like to able to select as well as the specific 'POSTITION' value Also 'BASE' and all those parameters that have a check box empty or full.
Thanks

SELECT tblCrewMember.StaffNumber, tblCrewMember.Surname, tblCrewMember.Name, tblCrewMember.Position, tblCrewMember.Base, tblCrewMember.Nationality, tblCrewMember.StartingDate, tblCrewMember.Resined, tblCrewMember.ResinedDate, tblCrewMember.Birthday, tblCrewMember.IDCrewMember, [GroupBy] AS Expr1
FROM tblCrewMember
WHERE ((([GroupBy])=[Position]))
ORDER BY tblCrewMember.StaffNumber;

 

[pr2-eugin]

Somethign like,

SELECT......
WHERE [B][GroupBy] = [Position] AND [Base] Is Not Null[/B]
ORDER BY tblCrewMember.StaffNumber;

 

[mtagliaferri]

Thanks Paul,
I tried the SQL however id does not work :-(
Maybe I have not explained properly what I need to achieve, the table I am trying to filter has various fields. when I launch the query it will have to ask various parameters, as first the 'POSITION' once that is entered then the 'BASE' and finally within the resigned parameters only those that are un-checked in the table.