field validation rule for access

[jasons4u2]

i have two fields PROJECT START DATE and PROJECT END DATE.
now i want to creat a validation rule so that the Project End Date will be greater than the Project Start Date.
Can any one please help me out i need this as soon as possible

[MMcCarthy]

I am moving your question to the Access forum where you are more likely to get help.

Mary

[MMcCarthy]

i have two fields PROJECT START DATE and PROJECT END DATE.
now i want to creat a validation rule so that the Project End Date will be greater than the Project Start Date.
Can any one please help me out i need this as soon as possible

In the validation Rule property of [Project End Date] put

>[Project Start Date]

[pks00]

I prefer the use of vba because u want to validate both start and end dates - thats if both are entered by the user.
Its possible for someone to enter a end date then a start date

eg

 private sub ProjectStartDate_BeforeUpdate(Cancel as integer)
    Cancel = ValidateDate
end sub
 
private sub ProjectEndDate_BeforeUpdate(Cancel as integer)
    Cancel = ValidateDate
end sub
 
private function ValidateDate as integer
 
    ValidateDate = false
 
    if isnull(Me.projectStartDate) = false and isnull(Me.projectenddate) = false then
        if Me.projectStartDate > Me.projectEndDate then
            msgbox "Invalid date"
            ValidateDate = true
        end if
    end if
end function