Combine two IIF

[USMCFROSTY]

Count(IIf(Right([Status] & "",10)='Achieved',1,Null))
What did the 10 represent?
PS, I picked up a book at the store but knowing first helps out.

 

[vbaInet]

That was a typo . It should have been either 0 or 1. It doesn't matter if it's 10 anyway.

Have you got it working?

 

[USMCFROSTY]

=["achieved"text19]+["In Progress"text20]-26
not working

 

[vbaInet]

The name of the Achieved texbox is certainly not ["Achieved"text19], neither is the In Progress textbox. Simply substitute the textbox names in there.

 

[USMCFROSTY]

I get a neg # so ill just put it up front. Also i think i need to compact, its picking up old info. But yes that works. Too Basic, i guess i was trying to complicate things. Off to lunch to read up on access.
THANKS FOR HELPING I WOULD HAVE SPENT HOURS.

 

[vbaInet]

Do you want it to be always positive?

 

[USMCFROSTY]

yes it will always be pos.

 

[vbaInet]

You can use the Abs() function -->

=Abs([AchievedTextboxName] + [InProgressTextboxName] - 26)

Enjoy your lunch!

 

[USMCFROSTY]

WOW now that i read your last post, it went right over my head, i feel stupid, lol
Thanks.

 

[vbaInet]

You need lunch - food for thought

You're welcome!