Day from date in a Form

  • Thread starter Thread starter Mike Abbott
  • Start date Start date
M

Mike Abbott

I would like to have a form into which I can enter a Club name and the date
it runs.

I only need the day it runs either as a string or number in my table.

I suspect access has a Day( value) function which will calculate this.

I also suspect I should use an unbound control to allow entry of the date.

I can't get the value into the table.

Thanks for any help.

Mike
 
Mike said:
I would like to have a form into which I can enter a Club name and
the date it runs.

I only need the day it runs either as a string or number in my table.

I suspect access has a Day( value) function which will calculate this.

I also suspect I should use an unbound control to allow entry of the
date.

I can't get the value into the table.

Thanks for any help.

Mike
Click to expand...


Store the date. For display use the expression...

=Format(FieldName, "dddd")
 
Back
Top