Current Week Day in Access Table

[John Keane]

Hi

I have a table which displays current DATE.
Can anyone tell me i can append the corresponding DAY of
week to it or in a another field.

Example: Tuesday, 14 September 2004.

Any Help appreciated.

Thanks
John.

 

[Allen Browne]

Set the Format property of the text box to:
Long Date
or:
dddd dd mmmm yyyy

In the context of a form, you may prefer to have the day name in another box
beside the original one. Set these properties for the 2nd text box:
Control Source =[YourDateFieldNameHere]
Format dddd