Help using COUNT(*) I need to count records in a table 1

[kristy123]

I have put a text box on the footer to tell the user the nubmer of records with the condition of "high priority" (that is a combo box on each record).
I don't know how to add the condition of the "high priority".

 

[tlbroadbent]

Select count(*) As Cnt
From tbl Where Priority="High"

Or perhaps...

Select count(*) As Cnt
From tbl Where Priority=1

You may even want to use DCount in a text box. Set the control source of the text box to

=DCount("*", "Tbl", "[Priority] = 'High'&quot
=DCount("*", "Tbl", "[Priority] = 1&quot Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost