Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation of dates entered

Status
Not open for further replies.
ignacious

ignacious

Technical User
Feb 11, 2004
11
US
I have an access database with DateReceived and DateCompleted box's.
I need to ensure that the date entered in the DateCompleted box is the same or later than the DateReceived box.

Thanks
Ignacious
 
Sort by date Sort by votes
You can set your validation rule for date completed to be
>=Me.[DateReceived]

HTH,

Steve
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
164
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
105
caykamanj1966
caykamanj1966
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
503
Andrzejek
Andrzejek
PohTek
  • Locked
  • Question
Bi-weekly due dates for loan repayments
Replies
2
Views
87
dhookom
dhookom
StevenFromSouth
  • Locked
  • Question
How to join tables to get current price of a product. 1
Replies
3
Views
95
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top