Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Table db Design > Counting non-bl...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 12070 of 12659
 Post > Topic >>

Counting non-blank fields in a record

by =?Utf-8?B?Um9n?= <Rog@[EMAIL PROTECTED] > Jul 31, 2008 at 01:17 PM

(Using a Re****t) I have 6 fields in a 10 field record that may or may not 
have data in them. I need to count the non-blank fields in that restricted

set of 6 fields and put that number in a separate field for that record. 
DCOUNT and COUNT don't work for this and there is no COUNTIF in Access. Is

there a way to do this? As always, the help is much appreciated!




 4 Posts in Topic:
Counting non-blank fields in a record
 =?Utf-8?B?Um9n?= <Rog@  2008-07-31 13:17:01 
RE: Counting non-blank fields in a record
 =?Utf-8?B?S0FSTCBERVdFWQ=  2008-07-31 14:33:05 
RE: Counting non-blank fields in a record
 =?Utf-8?B?Um9n?= <Rog@  2008-08-01 04:14:00 
Re: Counting non-blank fields in a record
 "Jeff Boyce" &l  2008-07-31 15:10:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan12V112 Mon Dec 1 22:09:41 CST 2008.