Creating Current totals in Form (Access 2003)

Topic

New Reply

I have a form with Check boxes and Combos. I want some fields in a Form that counts the responses and displays them in current status when the form is accessed:

1. Combo Box : Status: (copntains 3 variables): so I need the form to display how many records in the current Dataset that the form is accessing, are “Surplus” “In Use” or “Missing”
So I expect a field to display: number of Surplus : ##

2. Yes-No Field: I need to know how many Items are Yes….
So I expect a field to display: number of Computers recovered: ##

I can reuse the codes for any fields…
Thanks

Thanks

Reply | Quote

Replies

1) =Abs(Sum([Status]="In Use"))

2) =Abs(Sum([NameOfYesNoField]))

PS was the reply to post 715,562 helpful? You didn’t post a reaction.

Reply | Quote

Thanks Hans… this worked great….

nice to see the Totals on the form….

Reply | Quote