Hi
I am creating an access 2007 database for a preschool. I have all the essential data captured in one table, such as child details, contacts, emergency contacts etc. However I need to capture the days the child attends and need to query on this. what is the best way to do this? Do I create another table to record attendances or is there a calendar feature? I also want to calculate the cost per month and keep a track of this. What is the best way to do this?
Thanks in advance.