drisconsult
Drisconsult
- Local time
- Today, 00:04
- Joined
- Mar 31, 2004
- Messages
- 125
In my previous thread, I was seeking help on creating a query that will allow me to update a Class, such as Class 2A to Class 3A.
This happens at the end of every academic year in schools when each student moves up a year.
So my question is how can I update an entire Class from 1A to 2A, or from 3B to 4B?
I have a primitive solution but it simply isn't good enough. In my simple solution I load the query with just the class identifier and no names. This would normally mean about 30 to 35 students. I would then manually change each 2A to 3A or 3B to 4B.
Thanking the kind soul in advance, who I know is out there.
Terence Driscoll, London
This happens at the end of every academic year in schools when each student moves up a year.
So my question is how can I update an entire Class from 1A to 2A, or from 3B to 4B?
I have a primitive solution but it simply isn't good enough. In my simple solution I load the query with just the class identifier and no names. This would normally mean about 30 to 35 students. I would then manually change each 2A to 3A or 3B to 4B.
Thanking the kind soul in advance, who I know is out there.
Terence Driscoll, London