can i have a combo box that will only show mondays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am making a tab form with weekday titles. i was hoping that when in the
monday form when you want to select a date it would only show monday dates.
is this possible to do i though it mite be possible using a query and am
trying to figure out what the criteria should be. if anyone could help be
great thatnks.

yours

david
 
Use the function DatePart:-

DatePart(interval, date)

where the ineterval is "w" for weekday (include the quotes in the function)
starting with Sunday = 1 through to Saturday = 7.

Use this in a query to show only dates that are a particular day, eg for
Monday

SELECT TRANSACTIONDATE
FROM TABLE
WHERE DatePart("w",[TRANSACTIONDATE]) = 2;
 
Back
Top