Apr 1 2003, 07:22 PM
OK, i have a databse that has has about 50 criteria in it. Its basicly a chekoff sheet of things that need to be done on a given employee report. If somthing isnt done we put a check in the box and it goes into the data base. Now i am trying to build a query that will list by employee what infractions are taking place. So say John dosent sign 3 of his reports, i want a query that would saw john and then next to it would say the number of reports he didnt sign.
Apr 1 2003, 08:34 PM
Let me try to clarify what I think you are stating in your question.
Do you have a table with various criterea which indicate failure mode of some sort. Do you also have a table with employee names. or is all data contained in one table?
1. Have you set up primary keys on each table?
2. Do you need to break out a count for each of the 50 criterea per employee or just a total of all per employee?
Apr 2 2003, 02:58 AM
I agree with Happy Camper. What do you mean by "criteria"? Do you mean 50 different possible infractions for an employee report?
Counting records is fairly straight forward. Instead, you may have a problem with your table structure(s). Can you post a copy, with sample data? (.zip file)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here