Results 1 to 2 of 2

Thread: append by day

  1. #1
    Join Date
    May 2013
    Posts
    27

    Unanswered: append by day

    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.

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    Try this in your qry grid.
    =Format(CDate(Date())-(Weekday(CDate(Date())))+4,"m/d/yy")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •