Access Using Parameters and Criteria in Access 2003

G

gerryo

Joined
Mar 31, 2011
Messages
1
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Really, Really Need Help Tracking Employee Attendance 8
Using other equations inside of SUM? 1
I am trying to use the IF and SUMIF function on Excel 8
Access Need help with Simple HR Form in Access 2007 0
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Calculate leave time in a query 4
if statement = if number is between 1
Subtotals from one subreport to another 1

Top