Include field in table or create for each usage?

[louise]

Hello,


I currently have a field in my table, DayOfWeek, that I have been filling in via a ListBox in a form.
But, I now would like to have the day of the week automatically filled in when I enter the date. I have done this, so far, in a query like this:
DayOfWeek: Format(MeetingDate1, "dddd")

This works fine. But, now I wonder I should remove the field DayOfWeek from the table and recreate the field (as a text box?) in every query where this information is required? (This occurs in many places.)

Or, should I create it in each report, rather than the report's underlying query?

Or, can I put that expression into the table definition of the field and thereby do it only one time? And, then, would it update if changes are made via a form at a later date?

Thx for your help with my confusion about this!

[orange]

You do not need DayOfWeek in your table-- provided you have a field of Date data type (

I enter the date

)

Access has functions that can display WeekDay, WeekDayName of your date as and when required.

[alansidman]

Perhaps something like this.

http://www.baldyweb.com/Autofill.htm

[June7]

Agree with orange. If you are saving full date value, don't save day of week. Calculate it when needed.

Do not recommend setting display formats in table. I prefer to see actual value when I view tables. Also, the format will not always carry through queries, especially if the field is used in an expression - the actual value will be used.