Count records from form where txtbox="ABC"

  • Thread starter Thread starter Emanuel Violante
  • Start date Start date
E

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
 
Hi everyone,

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

Add an unbound text control to the form.
Set it's control source to:
=Abs(Sum([Field1]='ABC'"))
 
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


fredg said:
Hi everyone,

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

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