Display the day automatically for a given date

[Sludgeguts]

Hi all

I have Access 2003 Installed

am also new to Access

I have a simple (for the moment) database where I have 1 form and 1 table

If I create a Textbox in a form for inputing a specific date with its field in the table

can access input automatically the day for that date in another textbox and then record the day in a different field within the same table.

 

[Beetle]

You wouldn't want to actually store the day, just display it in a calculated field in a query or a calculated control (text box) on a form with;

Format([YourDateField]), "dddd")

I'm assuming by "Day" you mean "Monday", "Friday", etc.

 

[pbaldy]

I already gave you the functions to do it, Format() or WeekdayName(). I also recommended against saving it. If you feel you must for some reason:

http://allenbrowne.com/casu-14.html