Validation for data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/
 
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

Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
 
Bonbon said:
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
Click to expand...

You forgot the less than sign...

< Date() + 1
 
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/


Bonbon said:
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

Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top