Setting A Maximum Value

[Eranka]

Hi Please See above Image.

I have fields "Rate" and "Total_No_Of_Hours

If Rate Exceeds Than 1000 it should come back to 1000 and if Total No Of Hours Exceeds 20 then is should come back to 20. How to do this?

[isladogs]

First of all, change both fields to Number - Integer

You haven't said where you want to do this.
Various methods
1. Set validation rules for the fields e.g. <=20
2. Use If statements in vba e.g.

if rate>1000 then rate=1000

3. Use intermediate if expression (IIf) to do the same thing in code or a query

Rate: Iif([Rate]>1000,1000,[Rate])

Also don't use Date as a field name as it is a reserved word