W
Wullie
Hi,
After going round in circles, I've decided I need help.
I have a form which has 3 tabs for a pupils history in school.
The first tab holds the pupils information and works no problems, the third
tab has the qualificatuons and again works exactly how I want it.
The problem is the middle tab which has the attendance on it for each year.
Each row contains the number of possible sessions, the number attended etc.
and I would be looking to show a summary of totals for each year and a
percentage of attended/non-attended. If possible, I would also like to be
able to display each of the individual years.
I assume that the best way to display the data is in a subform, but am not
sure how I need to setup the subform and have it show different information
on each selection.
I tried to setup a combobox on the tab and select a year to have it refresh,
but a) the combobox would not select anything and b) I don't know how to tie
it all together, so any help would be greatly appreciated.
Thanks
After going round in circles, I've decided I need help.
I have a form which has 3 tabs for a pupils history in school.
The first tab holds the pupils information and works no problems, the third
tab has the qualificatuons and again works exactly how I want it.
The problem is the middle tab which has the attendance on it for each year.
Each row contains the number of possible sessions, the number attended etc.
and I would be looking to show a summary of totals for each year and a
percentage of attended/non-attended. If possible, I would also like to be
able to display each of the individual years.
I assume that the best way to display the data is in a subform, but am not
sure how I need to setup the subform and have it show different information
on each selection.
I tried to setup a combobox on the tab and select a year to have it refresh,
but a) the combobox would not select anything and b) I don't know how to tie
it all together, so any help would be greatly appreciated.
Thanks