I'm a newbie to all things databasey and I'm attempting to create a Time Sheet in MS Access. I've created a form already with appropriate fields on it but I'd like to improve the date input facility.
One thing I'd like to do is display the Day of the week, ie Monday, Tuesday etc in a field (or label) to help clarify the Date inputted. There will be an initial field where I would input '23/07/04' for example, this info would then be used to calculate the disired 'DayOtTheWeek' field accordingly.
I've looked at the 'datepart' function but it doesn't seem to do what I'm after. Surely something like DOTW is a simple operation, I must be missing something.
If anyone has any ideas on how to do this I'd be grateful.
Many thanks
Marc
One thing I'd like to do is display the Day of the week, ie Monday, Tuesday etc in a field (or label) to help clarify the Date inputted. There will be an initial field where I would input '23/07/04' for example, this info would then be used to calculate the disired 'DayOtTheWeek' field accordingly.
I've looked at the 'datepart' function but it doesn't seem to do what I'm after. Surely something like DOTW is a simple operation, I must be missing something.
If anyone has any ideas on how to do this I'd be grateful.
Many thanks
Marc