Validation for data

[Bonbon]

Hi, im a begginner in Access so please be ready for my question >.<

Im designing a table, and have a data field, i want to be able to make a
criteria so the date is any date before tomorow's date..
the field is called 'date of payment' so it couldnt be possible if it was
paid in next week, these payments should have already taken place..

any help would be greatly appreciated =]

BoN

 

[Jeff Boyce]

You could add something like the following to your field's Validation
property:
<Date()+1

By the way, does this mean you won't accept a "post-dated" check in
payment -- you know, "here's my payment, but don't cash it until Friday..."?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Bonbon]

thank u, i typed:
Date()+1
in the validation rule box, but when i type 31/12/06 as the date.. theres
an error saying 'one or more values are prohibited by the validation rule
'Date()+1'.. enter a value that the expression in this field can accept'.

please help, and sorry to be a pain but could you explain the expression u
give me? so i can learn what im actually entering, thanks a mil

BoN

You could add something like the following to your field's Validation
property:
<Date()+1

By the way, does this mean you won't accept a "post-dated" check in
payment -- you know, "here's my payment, but don't cash it until Friday..."?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Hi, im a begginner in Access so please be ready for my question >.<

Im designing a table, and have a data field, i want to be able to make a
criteria so the date is any date before tomorow's date..
the field is called 'date of payment' so it couldnt be possible if it was
paid in next week, these payments should have already taken place..

any help would be greatly appreciated =]

BoN

 

[Rick Brandt]

thank u, i typed:
Date()+1
in the validation rule box, but when i type 31/12/06 as the date.. theres
an error saying 'one or more values are prohibited by the validation rule
'Date()+1'.. enter a value that the expression in this field can accept'.

please help, and sorry to be a pain but could you explain the expression u
give me? so i can learn what im actually entering, thanks a mil

You forgot the less than sign...

< Date() + 1

 

[Jeff Boyce]

The "<" means "less than";

Date() returns today's day (or at least, the date your PC believes it is);

The "+1" adds one to today's date.

Taken together, the expression entered in the Validation rule says:

"This (entered) value must be less than tomorrow."

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

thank u, i typed:
Date()+1
in the validation rule box, but when i type 31/12/06 as the date.. theres
an error saying 'one or more values are prohibited by the validation rule
'Date()+1'.. enter a value that the expression in this field can accept'.

please help, and sorry to be a pain but could you explain the expression u
give me? so i can learn what im actually entering, thanks a mil

BoN

You could add something like the following to your field's Validation
property:
<Date()+1

By the way, does this mean you won't accept a "post-dated" check in
payment -- you know, "here's my payment, but don't cash it until Friday..."?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Hi, im a begginner in Access so please be ready for my question >.<

Im designing a table, and have a data field, i want to be able to make a
criteria so the date is any date before tomorow's date..
the field is called 'date of payment' so it couldnt be possible if it was
paid in next week, these payments should have already taken place..

any help would be greatly appreciated =]

BoN