First field populated...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure what the tech term is for it but here's my goal:

On a single record I have an item number with 12 fields for usage (each
month). I'd like to have a calculated field on the same record tell me how
many months the item had usage - value of >0. For example, if item ABC only
had usage in May and June, the value in my calculated field should be 2.

Thanks for any help!
 
In a query, you would use a calculated field.

Field: HowMany: 12 + IsNull(Month1) + IsNull(Month2) + ... + IsNull(Month12)

This works by adding minus 1 (the value of True) every time a month has a null
value in it.
 
Back
Top