Determining the day of the week far into the future.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have Access2003 and a form to book future dates.

The form is based on a query with the fields:
MessageID,
TodaysDate,
MessageDate,
Time,
Message.

Is there an expression I can put into this query that will
find the day of the week for some booked event year (or so)
ahead?

Please help, Frank
 
Many thanks - this worked brilliantly. I was lost in the
"WeekdayName Function".
Frank


message
Yes --
Future_Date: Format([BookedDate], "dddd")
--
KARL DEWEY
Build a little - Test a little


Frank Martin said:
I have Access2003 and a form to book future dates.

The form is based on a query with the fields:
MessageID,
TodaysDate,
MessageDate,
Time,
Message.

Is there an expression I can put into this query that
will
find the day of the week for some booked event year (or
so)
ahead?

Please help, Frank
Click to expand...
Click to expand...
 
Back
Top