Need Help Setting a Maximum Number

[kreelix]

Hello all. New to the forum here! I am taking my first Access course and I am having a little trouble with my tables. One table I have is for the number of hours an employee has worked. I am suppose to create some sort of rule that will not let the user enter a number greater than 40 in the field and if they try they will be given an error stating "The number of hours must not exceed 40."



Another part of this same problem which I know will tie to my first issue; I need to make it so that the date of hire for employees is either today's date or earlier. If an invalid date is entered, an error is displayed.

I was wondering if anyone could help with this. I am pretty hung up on it.

Edit: Wait...may have figured it out. Validation rules?! Working on it now....

Thank you!

[CJ_London]

in the control properties you will see under the data tab two properties - validation rule and validation text

in the validation rule put

>0 and <=40

(I presume you don't want the user to be able to enter a negative number

in the validation text put

The number of hours must not exceed 40

[kreelix]

Thank you. I just got actually right before you posted.

Now though, I am still stuck on the date part of things...

Would this work?

<Int(Now())

[ssanfu]

Try

<=Date()

FYI, I know this is an assignment, but I never do validation in tables. I do the validation in queries, forms or code because I have better control over the validation.