Day based on the Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

insideout786@gmail.com - 03 Dec 2006 22:55 GMT

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

Reply to this Message

Douglas J. Steele - 04 Dec 2006 00:13 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi,
> I am trying to create a table that has current date on first column and
[quoted text clipped - 10 lines]
>
> Am

Reply to this Message

ruralguy - 04 Dec 2006 00:19 GMT

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

>Hi,
>I am trying to create a table that has current date on first column and
[quoted text clipped - 10 lines]
>
>Am

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message