Hello, Please please please can someone help, I have been searching the internet for advice for hours!
I have bought a training DVD but it did not demonstrate the calculation I needed either.
I have created a fairly simple relational database for the Special Needs School in which I work, which logs behavioural incidents. Main tables are 'Students' - 'Generic Incidents' - Serious Incidents'
I need to create a calculation to count the number of incidents that occur each month, one to calulate generic incidents by month and one for serious incidents by month. The date field is simply called 'Date of Incident' which logs an incident day/month/year. I need to create a report for Governors on incidents by next week aarrghg!
Please can anyone help
Thanks a lot