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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top 5 grouping of material based on usage 2
Is there a way to make positive numbers appear as +XX ? 4
Dividing by zero in a calculated field of a query 4
populating data fields 5
sql query needed urgent 4
Calculated field 5
Calculate percentage 8
Count text values in a Access Field 0

Back
Top