G
Guest
Hi
Sorry if this is in the wrong group but Im a newbie on Access and am not sure under what are to ask this question.
So I have a database (In creation) that records the time spent on certain tasks carried out on a daily basis. As each task is entered the user enters a duration in this case in 1/4 days (eg 0.25, 0.5. 0.75 or 1 Day).
What i need to do is stop the user entering more than one days worth of time, but the user can enter anywhere up to 4 tasks per day, or any combination as long as it does not exceed 1 day.
How do I do this as the validation rule on the table wont allow refs to fields etc.
Is this a querie or some thing similar.
Any suggestions most greatfully recieved, but please remember Im a Newbie and will need to have the solution spelt out if it more than a little bit complicated.
Many thanks
GreenBoy
Sorry if this is in the wrong group but Im a newbie on Access and am not sure under what are to ask this question.
So I have a database (In creation) that records the time spent on certain tasks carried out on a daily basis. As each task is entered the user enters a duration in this case in 1/4 days (eg 0.25, 0.5. 0.75 or 1 Day).
What i need to do is stop the user entering more than one days worth of time, but the user can enter anywhere up to 4 tasks per day, or any combination as long as it does not exceed 1 day.
How do I do this as the validation rule on the table wont allow refs to fields etc.
Is this a querie or some thing similar.
Any suggestions most greatfully recieved, but please remember Im a Newbie and will need to have the solution spelt out if it more than a little bit complicated.
Many thanks
GreenBoy