hello everyone I'm needing some help with appending...
ok here we go. I have a taxi database I'm working on. 1 table "transit ID"
fields: date, day, destaddress, pickupaddress, cost, and mileage.
heres the problem. i have a list of clients that ride every week , and i don't want to enter there data everyday, so i created an addition table "reservID",
which is a duplicate of my tansitID table.(example Mr. teddy goes on every Wednesday)
i want to create an update query that will append only the info that is on my reservation table that is Wednesday, with the current date for that day.
i know i probably explained it wrong but ill give it a shot.