Hi,
I am trying to develop a form that will show the total number of records based on a criteria defined in a query.
On my form I have a unbound label called "Open Orders" beside that I want to show the total number of "Open Orders"
Each record in the database has a option group, it is 1=Open, 2=Closed and so on.
I created a totals query and isolated the option group "Status" to only show items in status "1" it then pulls all the records with a status "1". In the totals row I placed "Count"
On my form I added a txtbox with the control source CountOfStatus from the query however it is only showing a "1" not the total count?
Can anyone help?
Thanks!
Fen How
I am trying to develop a form that will show the total number of records based on a criteria defined in a query.
On my form I have a unbound label called "Open Orders" beside that I want to show the total number of "Open Orders"
Each record in the database has a option group, it is 1=Open, 2=Closed and so on.
I created a totals query and isolated the option group "Status" to only show items in status "1" it then pulls all the records with a status "1". In the totals row I placed "Count"
On my form I added a txtbox with the control source CountOfStatus from the query however it is only showing a "1" not the total count?
Can anyone help?
Thanks!
Fen How