Hi there,
So if anybody can help me with this I would be really thankful. I am creating a database for a school whereby it logs all bus riders and their locations times etc. Now that bits finealong with all the reports etc but this is the real issue I have.
I want to automate kids that will not be riding the bus on certain days because they are ill or getting picked up whatever the reason so when reports are printed it leaves them out but also keep a table of results of who didn't ride the bus when. What is the best way to design a system to allow this. I understand that I would need some sort of entry screen to select students not riding but how do I keep a record of all these dates they do not ride for reporting purposes and also not harm the original database and allow a report to be run showing who is and is not riding that day for checking everyone who should be is on the bus and those who shouldn't are not.
If keeping it super simple just for try out purposes lets say these are the fields and their table:
STUDENT BUS
Student name
Route Name
Bus Stop
Riding bus?
Hope someone can help. I was guessing I would have the main table STUDENT BUS and then maybe need another called BUS LOG or something that populated this from as Form and the report run from a query set to calculate the report for that day.
PLEASE HELP!!!
Thanks