Search results

Thanks Pat... yea... got a little carried away there splitting the thread. My thinking was one being a technical how-to and the other a mental walk of what's the best approach to recording a continuously incrementing number like an odometer. The current business model is drivers record their...

Can you expand on that a bit more DBGuy? Each trip record would have the start and stop OD from which I can get # miles driven for that trip. I could calculate the total differences for bus 1 for a period of X days. It is the last OD reading technically. But if driver 1 puts his OD entry in...

90% of the trips are short, 2 or 3, 5 to 20 mile trips per bus. On occasion, our "Day Tripper" buses will take kids on a long excursion and sometimes over night. Count is the head count per student. Code is the type of trip - To/From, Field, Activities and Misc (maintenance runs). I still need...

Hey all, Several folks have noted that my table design is incorrect and I now see why but I can't think of a better way to design it. Here is what I have. Vehicle table - ID, VehicleName, CurrentOD Trip Table - ID, Vehicle, Depart-OD, Return-OD I need to track current mileage per bus. I also...

Thanks... Dale actually reached out to me with a reply and told me to export with "Menus and Toolbars" selected. I had not done that prior but now its working. :)

Here it is... it has some sample data.

I think it is in here... This is from mod_DateTimePicker.

I think I get what you mean. I had not thought about record entry out of order. That would be a problem. So instead of writing out the return OD... I should calculate the difference between the start and return OD and increment the bus current OD by that amount. That way, it would be...

I set this to run when the Save Button is clicked.

UPDATE Vehicles INNER JOIN Trip ON Vehicles.VehicleID = Trip.VehicleName SET Vehicles.CurrentOD = [OD_Return];

Thanks for the quick reply. I have the sample database, where would I look for this?

Hey all, Again, relearning Access after many years away. I am building a ridership database. I have the following sort of working. Each record is associated to a specific vehicle so that's a combo box. Selecting the bus ID pulls the current_OD from the table and puts it into the "Odometer at...

Hey all, First post here. Been a long time since I have done any database work so I am on a steep relearning curve here. I am building a database for our school transportation department to track ridership. They have been using spreadsheets. :-( I crafted the following relationships and have...