Report Criteria

[lansel]

I have a query that creates a report that list all the employees absences and then totals the absences. The report is grouped by employee number so all the dates and information for that employee is grouped with their total.

I created a report from the same query that just listed the employee and their total incidents. I want the report to list the employees that only have a total of more than 5.5 incidents. In order to list all the incidents for the first report, I had to use the criteria >0 under the field "incidents". I did the second report calculations on the report. How do I get the second report to list only the employees that have more than 5.5 incidents?

I tried this in another query and report and the query didn't like the half points. I submitted a message for help early last week but I did not receive any suggestions? This is really driving me nuts!!!

Thanks,

Linda

 

[lansel]

Query Problem

Thanks for your response.

If I am understanding your note, in the query in the "Incident" Field (the field that has the numeric number of absences), I can enter the following in the criteria:


"Incident" > [5.5]

Is that correct?

 

[lansel]

Thanks for your help!! I finally got it to work.

 

[lansel]

Thanks for responding.

I am having problems planning the flow or process to reach the end result. The end result is populating a table in another database with information from a report.

1. My task was to create an improvement notice for an employee's excessive absences, which I did from a query and this query pulled the information from a table. All you have to do to create the report is enter the employee's number and you have a report that has all the employee's absences.

2. There is another database that issues improvement notices for an employee's performance and when an improvement notice is issued there improvement notice information is entered into a form and it goes to a table. If an employee's history is needed it is pulled from the table into a report.

3. What management is wanting, when the absence improvement notice is issued, they want that information from the report to merge into the other database's table. So when the history is needed, all information will be in one table. The information is only merged into the other table when the improvement notice (report) is issued.

4. I am having real difficulty in planning what I need to do to reach the end result. Please help!