From a date field I want to store a week number, and a weekday name

  • Thread starter Thread starter Newsgroups
  • Start date Start date
N

Newsgroups

I have a table with a number of fields, which store dates.
I will need to produce reports based on week number, and also weekday names.
I will be creating a form to enter the dates, and a form to display the
results, including the date, week no. etc.
Should the week no. and weekday name be stored in the table, or just as a
calculation.
I will later need these two bits of information for queries, and later
reports.

Mark
 
Newsgroups said:
I have a table with a number of fields, which store dates.
I will need to produce reports based on week number, and also weekday
names. I will be creating a form to enter the dates, and a form to
display the results, including the date, week no. etc.
Should the week no. and weekday name be stored in the table, or just
as a calculation.
Click to expand...

Neither. You recalculate the result each time you need it. You can do
that in a query and then base forms and reports on the query, or you can do
it in the form or report. You don't store any of that in a table.
 
Back
Top