If you try the report on the attached database, the report runs about 150 DCount functions to show the information that is requested.
It is REALLY slow to open and not sure if there is anyway I could speed it up. The database has been set out with tblAudit as the table that stores the questionnaire information and then it has 4 parts. Part 1 must be completed and has 37 questions that must all be filled in for Part 1 to be complete. Then Part 2-4 should be completed if applicable and if attempted all questions should be answered for each part. So I thought it would be right to set it out the tables in 'Parts' because the questions where whole to the key and part would not exist if all the questions were not answered.
It was suggested in a previous DCount post that I could change the table layout to normalise it better, but wasn't sure how to link the tables up properly and not sure if this could be why it is slow.
Give a go and see what you think. Thanks for any help.
I have also posted in the tables and relationship forum because it might be a normalisation issue.