I use Access 2007 to manage a transportation program at a Senior Center. I'm not a big user of SQL, but have used Access enough that I usually can figure out how to do fairly straight-forward things. The main table in my database is a table that has all of the rides in it.
One of the things I frequently need to do is query this table for all of the requested rides for a given date. I have the query request the date for input, which starts out working like I want it to. After some random period of time, the query suddenly starts asking for the date twice! It's not a big deal, but it's annoying. The only way I've been able to get it back to normal is to re-construct the query. Then it's fine for a while, but eventually starts asking for the date twice again. In case it might be helpful, here's the SQL for the query: SELECT Tbl_Rides.Pickupdate, Tbl_Rides.Rider, Tbl_Rides.Pickupadd, Tbl_Rides.Pickuptime, Tbl_Rides.Appttime, Tbl_Rides.Destination, Tbl_Rides.Destphone, Tbl_Rides.Status, Tbl_Rides.Notified, Tbl_Rides.Driver, Tbl_Rides.Notes, Tbl_Rides.Notestome FROM Tbl_Rides WHERE ((Tbl_Rides.Pickupdate)=[What date?]) ORDER BY Tbl_Rides.Pickuptime; Any ideas? Or is this just a Microsoft "feature" that I'll have to live with? Barbara Mann Transportation coordinator Yellow Springs Senior Center Yellow Springs, OH
