Thank you. It makese sense now. I have managed to get the reports totalling in the required format.
I just have one final query, and then my database is finished.
On the 'Basic Hours Report', the log numbers are not correct. It seems to be counting the number of visits, rather than displaying the person's static log number.
sounds good... and yes you are correct it counts the numbers of visits because if you bring in the log numbers then it will be the same as the other report..
..by the way finish of by creating a new blank form, go to design mode and put some buttons on to open the different forms, reports and one to quit access. It's all step by step wizards. Then go into property for the form and set record selectors and navigation buttons to No. Then save the form..
Then goto file>options>current database and set display form to your new form and you can look at the other options like application title, icon etc.. Then restart Access..
Now if you want to work on the database you have to hold down shift while it opens..
I think the success of this database has gone to my head, because I have now tried copying code to create a 'search' function on the 'CC Form'. It hasn't worked, predictably.
