Day based on the Date

  • Thread starter Thread starter insideout786
  • Start date Start date
I

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
 
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.
 
Back
Top