HOW USE FUNCTION WEEKDAYNAME OR WEEKDAY IN ACCES

[Rick B]

Well, what are you trying to accomplish? Your question is too vague.

Please turn off your caps lock and give us some details.

Rick B

 

[John Vinson]

On Fri, 15 Apr 2005 11:59:03 -0700, CARMEN

Please ask your question *in the message text area*, not just in the
Subject line; and post enough details to allow someone to understand
what you want.

I believe that these are Excel functions not available in Access. You
can use

Format([datefield], "dddd")

to get "Friday"; or DatePart("w", [datefield]) to get 6 as the day of
the week.


John W. Vinson[MVP]