Hi,
I've been given an Excel list with almost 700 rows and two columns.
A: name of school
B: number of pupils who met a certain criteria, could be anywhere from 1 to 100.
I have imported that list to Access and I will need to add more information for individual pupils.
So as a first step I would like to create a table that lists School A 30 times, school B 50 times, etc. until there's around 12,000 rows in the table.
Is this possible? Now that I have the data in Access, my field names are
Schoolname - text
Entries - Number
I don't know whether to tackle this with an append query, or with VBA. Either way, I'm well out of my depth!
I've been given an Excel list with almost 700 rows and two columns.
A: name of school
B: number of pupils who met a certain criteria, could be anywhere from 1 to 100.
I have imported that list to Access and I will need to add more information for individual pupils.
So as a first step I would like to create a table that lists School A 30 times, school B 50 times, etc. until there's around 12,000 rows in the table.
Is this possible? Now that I have the data in Access, my field names are
Schoolname - text
Entries - Number
I don't know whether to tackle this with an append query, or with VBA. Either way, I'm well out of my depth!