Count of fields containing zeros

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

Guest

I am reposting this because I did not explain it properly. My apologies to
everyone

Hello,
I have a table

Field 1 = 45
Field 2 = 57
Field 3 = 0
Field 4 = 0

Field 5 = "How many fields have a "zero" in them. Which would equal 2.

How can I go about setting up field 5. I am not sure on how to use the Count
Property properly. Thanks for your help!

Derek
 
Field 5 should not exist in your table.

If you really need it, create a query that gives the count, and use the
query wherever you would otherwise have used the table.

To determine the count, you can use:

Abs((Len([Field 1]) = 0) + (Len([Field 2]) = 0) + (Len([Field 3]) = 0) +
(Len([Field 4]) = 0))
 
Back
Top