Results 1 to 4 of 4

Thread: filter by day

  1. #1
    Join Date
    May 2013
    Posts
    27

    Unanswered: filter by day

    Hello once again everyone.. im stuck with a problem and need some help..
    i have a PassengerID table... with consist of name, address, dayoftrip. what i want to do is to find a vb code or expression that can give me the results im needing.. my dayoftrip field is a combo box fors days (sun-sat) what i want to do is when a day is selected it will associate that field with the current... example..... shelia wants to ride on m,w,fri, and tom wants to ride on m,thur,sat.. lets say today is monday.. i want to be able to see only the trips for that day... but if its was tuesday i would see no passengers, because both shelia and tom is not working on that day. i hope i explained it right

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    All you need to do is use your combo and filter by Day.
    Find a record on my form based on the value I selected in my combo box.

  3. #3
    Join Date
    May 2013
    Posts
    27
    wow that was easy . thanks alot Burrina

  4. #4
    Join Date
    Nov 2011
    Posts
    413
    Your Welcome,
    Good Luck with your project.

Posting Permissions

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