Count records from form where txtbox="ABC"

[Emanuel Violante]

Hi everyone,

I would like to have the total count of records from my form where in
Field1, the value is "ABC" for exemple
--
Thanks,

Sorry if my english isn''t correct, but I''m from Potugal

Emanuel Violante Galeano

 

[fredg]

Hi everyone,

I would like to have the total count of records from my form where in
Field1, the value is "ABC" for exemple

Add an unbound text control to the form.
Set it's control source to:
=Abs(Sum([Field1]='ABC'"))

 

[Emanuel Violante]

That solved my problem just fine

Thank you verry much

Sorry if my english isn''t correct, but I''m from Potugal

Emanuel Violante Galeano

Hi everyone,

I would like to have the total count of records from my form where in
Field1, the value is "ABC" for exemple

Add an unbound text control to the form.
Set it's control source to:
=Abs(Sum([Field1]='ABC'"))