Generating statistical reports for those below 85%

[mcelligott]

Hello all,

I have a report I would like to generate and just can not get the coding figured out. Here is what I have:

My table has each record with the employee ID and sixteen questions (they check yes, no or N/A to each of the questions). I am looking to generate an on-demand report for only those employees that scored 85% or less in any of the questions (it is a compliance thing) for a given date period (ex: 1/1/09 - 1/31/09).

I have been able to generate reports (using dlookup and dcount) with all kinds of statistics (for each employee, platoon or the whole department). They each generate only a one page report. I could probably get the statistics for each of the employees on a specific platoon to print out but can not figure out how to limit it down to only those employees where any of their compliance levels are below 85%.

Anyone have any helpful suggestions? PLEASE.

Thanks,

Bob

 

[dhookom]

Share your table structure. I expect you have mistakenly created 16 fields for 16 questions rather than normalizing your tables to create a record for each question/response.

I assume there is some sort of answer key table or record that can be compared to determine if the answer is correct.

I believe if you table structure was properly normalized you wouldn't need to "generate reports (using dlookup and dcount) with all kinds of statistics". Your statistics could be simple aggregates in totals queries.

Duane
Hook'D on Access
MS Access MVP