Date Validation

[Shooting Star]

Hey,

I am making a database about carpets. I need the Date of Fitting field validated so it won't allow dates to be entered which are before the dates entered in the Date of Quote field.

E.g. if the Date of Quote field was: 01/01/2009, the Date of Fitting field could not be a date before that.

How would I go about achieving this?
Thanks in advance!
- Steven

 

[boblarson]

You can set a table level validation by going to the table in design view and then go to VIEW > PROPERTIES and then in the Validation Rule line put

[Date of Fitting] > [Date of Quote]

 

[RuralGuy]

Have you used the Search function here? How about:
http://www.access-programmers.co.uk/forums/showthread.php?t=166059

 

[Shooting Star]

Thanks for both of your help! Much appreciated.

 

[RuralGuy]

I prefer to validate in the Input form rather than the table so I have finer control over the validation and the error messages displayed.

 

[hunter_vs]

hi - thanks i got this to work .
can someone please give me some guidance on how i can make the field mandatory, i.e if the user does specify a date before the admission date, a message box will appaer, how can i make it so that the user CANNOT go to te next tab, unless an appropirate date is filled in.?
thanks

 

[RuralGuy]

Several way to skin this cat but I prefer to make the form force the user to use it in the proper fashion. I would keep things disabled until you have the data you need.