Query Help

[lansel]

I have a query that creates a table that add up all attendance points for employees. The total include half points. I have another query that uses the information from the table where I want to pull all employees that have greater than 5.5 points in attendance. The query will not pull any employee that has a half point in their total. I have tried changing the format of the number in the table and the query will pull the information if it is a full point, but that really isn't what I want. I need an accurate total.

Please help.

 

[dcx693]

What type of field are you using to hold those attendance points. It needs to be either the single or double numeric type to hold fractional amounts.

If it is one of those, can you post the criteria that you are using to pull results from the table?

 

[lansel]

I'm using double and the criteria for the total incidents is >5.5