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!