• There seems to be an uptick in Political comments in recent months. Those of us who are long time members of the site know that Political and Religious content has been banned for years. Nothing has changed. Please leave all political and religious comments out of the forums.

    If you recently joined the forums you were not presented with this restriction in the terms of service. This was due to a conversion error when we went from vBulletin to Xenforo. We have updated our terms of service to reflect these corrections.

    Please note any post refering to a politician will be considered political even if it is intended to be humor. Our experience is these topics have a way of dividing the forums and causing deep resentment among members. It is a poison to the community. We appreciate compliance with the rules.

    The Staff of SOH

  • Server side Maintenance is done. We still have an update to the forum software to run but that one will have to wait for a better time.

O/T Database constraints?

A

airtj

Charter Member
Does any know how to add a constraint to a field in Microsoft Access 07? I'm taking a course in college on database management. I've looked on the internet but haven't found any examples for Access. For example a zip code requires 5 digits and if you enter more it will reject the numbers.

Thanks for your help
 
The range of US zip codes runs from 10001 through 99950, so your rule would look like this:

>= 10001 And <=99950
 
airtj said:
Does any know how to add a constraint to a field in Microsoft Access 07? I'm taking a course in college on database management. I've looked on the internet but haven't found any examples for Access. For example a zip code requires 5 digits and if you enter more it will reject the numbers.

Thanks for your help
Click to expand...
Use the Input Mask for a table field. :jump:

--WH
 
You must log in or register to reply here.
Back
Top