Thanks Cap, but what I really want is the name of the day, Monday, Tuesday, that equates to the date in ERT, so if ERT is = 25-May-2006, I want the fiedl to show Thursday.
Das...
Das_EEjit
Last Activity: May 24 '06, 02:43 PM
Joined: May 23 '06
Location:
-
MS Access and caluclating weekdays
Hi folks
This may be a simple problem for someone, there again, it may be impossible.
I have a table which contains three fields, amongst other, :-
Logged
ERT
Day
What I need to do is to make ERT 2 days from logged, unless ERT falls on a Saturday/Sunday, in which case it should be Monday, and I need to the day, i.e. Monday, Tuesday etc, in DAY, so that
If logged = 25-May-2006,...
No activity results to display
Leave a comment: