Access Database Homepage

The know how and power behind access database

Want to teach yourself Access? Free online guide at About Access Databases

Learn Access 2b Planning A Database English Captions Music Ken Gaines Pool
Planning a database, part b what to know before you create access objects ... naming conventions leszynski reddick questions why addresses and phones are stored in separate tables field ...

Question: If statement in access database table to auto-fill field?

(Posted by: Evil-Dog on 2010-05-20 03:15:50)

I have a database and I'm trying to make it so that when fields 1, 2 3 and 4 are equal to "y " then put "yes " in a field (the field is called Pass). I am using Access 2007 and an Access 97- 2003 database.

Answers:

Posted by: fathermartin121 on 2010-05-20, 23:43:41

The formula is = if( "field 1 "= "y ",if( "field 2 "= "y ",if( "field 3 "= "y ",if( "field 4 "= "y ", "Yes ", " ")))) This worked in Excel. I imagine you will be using the formula in a query.

Back to Previous page

Google News will be listed here

Go Articles will be listed here

Want to teach yourself Access? Free online guide at About Access Databases

Sitemap | Terms of Use | Privacy Policy | Contact

Legal Notice: This website is powered by Amazon®, Adsense, Clickbank®, Yahoo!® Answers and Youtube. All trademarks are copyrighted by their respective owners. Please read our terms of use and privacy policy.