Day based on the Date

[insideout786]

Hi,
I am trying to create a table that has current date on first column and
a day based on the current date. Can someone please help me with this?

For Example:

Date Day
11/01/2006 Wednesday

and so on.

Thanks in advance.

Am

 

[Douglas J. Steele]

Hopefully you're not trying to store the day in a field in the table. All
you need is to add a computed field to a query, and use the query instead of
the table.

To get the day name for a given day, use Format(DateField, "ddd") to get
Mon, Tue, Wed, or Format(DateField, "dddd") to get Monday, Tuesday,
Wednesday.

 

[ruralguy via AccessMonster.com]

Please do not multi-post. Answered in another thread.