Recent content by geoffD

History: I have a database which is running well and has been in use for a few years. We have several Vans which transport patients from outlying areas to a central facility. The system works well in scheduling pickups. It has modules to check loads (prevents overbooking), make recurring...

Clashing Events/Appointments You might try reading this site http://members.iinet.net.au/~allenbrowne/appevent.html It has been around a few years but is still valid. I have used this technique in scheduling volunteers for marathons etc to insure that I haven't assigned them overlapping schedules.

Thanks for the reply. You of course are correct. I finally got everything working, so thanks.

I have a form with two sub-forms. The subFormOne is a continuous form that list Entries in a competition with EntryId as key field. The Link-Field, for both, is CompetitionId. the second sub-form is linked on CompetionID & subFormOne!EntryId. The second sub-form has two UNBound fields...

Hey I got it to work thanks. By adding the zero value I could then run another query with the union as the source and just sum the values. Thanks for the help. sometimes all you need is some one elses ideas to provide the spark!

Well, That is close. But I still get two lines. ie. Date Car No. Available In Available Out 2003/11/12 13 0 2 2003/11/12 13 3 0 When what I want is 2003/11/12 13 3 2 hope the formating...

My database deals with transporting people in Vans between cities. The vans are assigned a van #. tabels are tbl_trips: (passenger trip) with fields Trip_Date, Van# inbound, Van# outbound, Number of passengers, Passneger name, and others tbl_Van_Capacities with fields Van #...