McScripta Posted September 11, 2015 Share Posted September 11, 2015 I'm trying to create a calculation field that would hold count of fields with value in them (out of a range of 6).For example, I have fields: fld1, fld2, fld3, fld4, fld5, fld6. If fld1 has anything in it, my calculation field would display 1, if fld1 and fld2 had something in them, calculation would display 2, etc. Calculation field would be blank if none of the fields would have values in them. What's the best way to approach this? Link to comment Share on other sites More sharing options...
comment Posted September 11, 2015 Share Posted September 11, 2015 The Count() function does that. There is probably a better way to do whatever it is that you're doing. You didn't tell us what it is, but having numbered fields is almost always a symptom of bad data structure. Link to comment Share on other sites More sharing options...
McScripta Posted September 11, 2015 Author Share Posted September 11, 2015 thanks, I suppose I should've used repetitions... it's ok for small application as it is Link to comment Share on other sites More sharing options...
comment Posted September 11, 2015 Share Posted September 11, 2015 I suppose I should've used repetitions... I suspect you should use records in a related table. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3313 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now