Query Parameters Returning All Results

[turk1559]

Hi y'all. I'm trying to filter a query using multiple parameters, but I keep getting the entire unfiltered query. I want to be able to input some parameters and skip others by leaving them blank but the two potential methods I've been able to come up with result in either all results being shown or nothing being shown when I leave a parameter blank. Any ideas?

SELECT I.IID, I.IncidentDate, D.Shift, I.EID, EI.EmployeeName, D.DepartmentName, D.Supervisor, C.ReportCategory, I.IncidentDescription

FROM ((I INNER JOIN C ON I.[CID] = C.[CID]) INNER JOIN D ON I.[DID] = D.[DID]) INNER JOIN EI ON I.[EID] = EI.[EID]


GROUP BY I.IID, I.IncidentDate, D.Shift, I.EID, EI.EmployeeName, D.DepartmentName, D.Supervisor, C.ReportCategory, I.IncidentDescription


HAVING ((((I.IncidentDate)=[When was the report filed?],"*") AND ((D.Shift)=[Which Shift?] OR "*") AND ((I.EID)=[Target Employee ID #] OR "*") AND ((EI.EmployeeName)=[Employee's Name? (First and Last)] OR "*") AND ((D.DepartmentName)=[Which Department?] OR "*") AND ((C.ReportCategory)=[Which Category?] OR "*"));

[pbaldy]

It will get messy in design view, but here's one way:

http://access.mvps.org/access/queries/qry0001.htm

personally I'd use a form for user input.

[turk1559]

That sounds like the opposite of what I'm trying to do. I want to set it up so that if I only input employee ID it will give me only entries with that employee ID. If i do the ID and department, its just filtered by the id and department etc etc

[pbaldy]

Did you try it?

[turk1559]

Well I'll be damned it worked like a charm. Thank you!

[pbaldy]

Happy to help!