I am using Access 2003 and trying to set up a query with 3 parameters (employee number and date range) with criteria in 2 fields (hours taken for sickness and vacation). It works fine with only one field (say Sick Hours Taken), but returns all employees with hours in eith Sick or Vacation time for the entire database when the second field criteria is added.
Parameter 1 - "Enter employee number"
Parameter 2 - "Starting on which date?"
Parameter 3 - "Ending on which date?"
Criteria 1 for field "Sick time" - >"0.00"
Criteria 2 for field "Vacation time" - "0.00" in the second criteria
What am I doing wrong and how do I set up to achieve the info requested?
Parameter 1 - "Enter employee number"
Parameter 2 - "Starting on which date?"
Parameter 3 - "Ending on which date?"
Criteria 1 for field "Sick time" - >"0.00"
Criteria 2 for field "Vacation time" - "0.00" in the second criteria
What am I doing wrong and how do I set up to achieve the info requested?