mohamedmatter
Registered User.
- Local time
- Today, 03:56
- Joined
- Oct 25, 2015
- Messages
- 112
You have not even bothered to make an attempt?I want the total number of schools by stage. When the stage is changed, the number of schools is updated
I insert attach sample school database
thanks but i like counter in form by event help meUse a totals query. Group by Stage, Count by School
Code:SELECT Schooltbl.Stage, Count(Schooltbl.SchoolName) AS CountByStage FROM Schooltbl GROUP BY Schooltbl.Stage;
I tried, but it didn't work, there were errors such as not updating the valuesYou have not even bothered to make an attempt?
HiI tried, but it didn't work, there were errors such as not updating the values
how can move value in form and when change stage in form update valueMake a query from what @isladogs has supplied, then use a DCount() for the relevant stage against that query.
how move value to formHi
Using Colin's Totals Query produces the following result:-
Colin,I've no idea what you mean but you can display the results of the query in a subform.
If the data changes, just requery the subform to get the new values.
Time you tried for yourself
You can create a Form in Continuous View based on your Table.how move value to form
Fair point.If you want to use DCount, then no need for the query. Just base it on the table.
However, I wouldn't use DCount precisely because another stage such as Tertiary might get added at some point.
I would scrap those 3 controls and just display the results in a subform
I've no idea what you mean but you can display the results of the query in a subform.
If the data changes, just requery the subform to get the new values.
Time you tried for yourself
I found a solution, but I encountered a simple problem, please help. It is when the stage is changed, the values are not changed after the stage is updated. I have attached the rule after the modificationI've no idea what you mean but you can display the results of the query in a subform.
If the data changes, just requery the subform to get the new values.
Time you tried for yourself