Roll over of year groups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am aware that this may not be possible in Access but thought that it would
be worth finding out.

I have a large database of pupil records and would like to be able to run a
query that rolls over the school year groups automatically.

any help with this would be great
 
Bamf,

I would guess that this would be possible with Access. In fact, this
sounds like the kind of thing that Access is specifically good at.
Possibly this would involve an Update Query.

Please provide more details of the meaning of "rolls over the school
year groups", with examples, if you need more explicit help with this.
 
Excellent, as you can probably guess I am quite new to this!!

I have a field in my master table called NCY which has values from (-1)
through to (14). At the beginning of September each year I would need to
move all pupils up one year group to reflect the change of school year.

Any help or advice would be very much appreciated
 
Bamf,

What happens to those where the value is already 14? Do those with -1
get changed to 0?

Make a query based on the master table, and add the NCY field to the
query design grid. Make it an Update Query (select Update from the
Query menu), and then in the Update To row of the grid, put like this...
[NCY]+1
Run the query (click the toolbar button with the red [!] icon).

If you want to automate this process with a macro, you can use the
OpenQuery action to run the update.

You will probably want some dort of measure in place to make sure it
doesn't get done twice!
 
Back
Top