John, Thank you!
I still have a problem, when I entered that validation rule I got the message: Invalid SQL syntax - cannot use multiple columns in a column-level CHECK constraint.
I don't know what this means. Can you help??
Thanks once again!
Marwa
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Marwa-
>
> You can do it in the table directly. Open the table in Design view and then
> open the Properties window. In the Validation Rule, enter:
>
> =IsNull([Date Of Death]) Or (([Date Of Death] > [Date of Birth]) And ([Date Of
> Death] < Date()))
>
> In Validation Text, put a meaningful message such as:
>
> Date of Death must be later than Date of Birth and earlier than today.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Marwa Abo Amra
> Sent: Wednesday, June 29, 2011 1:23 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Validation Rule for Date
>
> Hi All,
>
> I need help in writing a validation rule for entering a date in a field. I have
> a form that has two dates to be entered: Date of Birth and Date of Death. I
> would like to write a validation rule in the Date of Death control so that users
> can only enter values greater than date of birth and before today. I am not sure
> what to write in the validation rule of that field in the table that I created
> the form from so the form cannot accept any values of date that I mentioned.
>
> Waiting for your assistance, pals!
>
> Thank you.
>
> Marwa
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar