Counting records with criteria and outputting to text box

[rich01]

Please help !!!

I have a database that users log service calls into.

One of the forms they go into only shows service calls that are outstanding (haven't been given to an engineer).

I have a Call status field which can have the state "Outstanding".

Basically I want to produce a query or whatever to count the number of records that have the criteria "Outstanding" and output a total to a text box.

I want this so when they go into the database it will show the number of calls that are outstanding before they even go into the outstanding form.

Please help !!

Am I being a complete dope ???

Cheers

Rich

 

[tlbroadbent]

Set the control source of the text box to

=DCount("*","TblName","[Status]='Outstanding'&quot

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[rich01]

Cheers Terry your are the don !!

Work like a charm !!

Thanks very much for your help !!

This website is the best thing on the net !


Thanks again


Rich