If you are talking about a form, a validation before the data is inserted to the table, then on the before update event of the form you can run the code If (Nz(Me.OAP,0) + Nz(Me.Child ,0) + Nz(Me.Adult,0)) > 4 Then MsgBox "All fields can't be greater then 4" Cancel = True ' Wont let the user save the record End if -- Good Luck BS"D "Damo447" wrote: > I have created a ticket system. > > In one table I have the fields OAP, Child and Adult. > > No field is allowed to have a greater value (but can be equal) than 4 and > collectivly they must be equal or less than four. > > Do you know a validation method which would agree with these requirements? > > Please help!