weekday

S

ssddteam

I am trying to populate a field called tour utilizing the weekday from the
field date. For example the date is 8/8/05 and the tour date would populate
as a 2 indicating monday.

Thanks
 
D

Dodo

I am trying to populate a field called tour utilizing the weekday from
the field date. For example the date is 8/8/05 and the tour date would
populate as a 2 indicating monday.

Thanks
Click to expand...

Suppose the date is in A1: =weekday(A1)
 
S

ssddteam

In access a form was created the field names are name date and tour. I want
to be able to enter in a date in the date field and have the tour field
populated with the day of week as a number( 1 Sun, 2 Mon 3 wed and so on).
 
D

Douglas J Steele

Don't do it! You should never store redundant data, nor data that's
completely derivable from other data in the same row.

Instead, create a query with an additional computed field that returns the
Weekday (using the Weekday function), and use the query wherever you would
otherwise have used the table.
 
Top