Please Help - Show count of records based on field entry

[james3188]

Hi, I'm afraid i don't know if this is in the right part.

I simply want to populate a text box on my page that shows the total number of records where a field (Status) shows 'LIVE'

 

Can someone help me please

 

Thank you

[comment]

I simply want to populate a text box on my page that shows the total number of records where a field (Status) shows 'LIVE'

It depends. Do you want to consider all the records in the current table? Or just those that happen to be in the current found set? Or perhaps these records are in another table, and you want to count among those are related to the current record?

P.S. Are you really using version 11? If not, please update your profile.

Edited August 3, 2015 by comment