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
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