Create a new "table" to fill in

[andy49]

I have three tables.



tblstudents
upn (special code for each student)
other stuff like first name etc

tblscores
PaperId,
upn
score1,
score2,
Tot (sum of score 1 and 2)

tblpapers
PaperId
Lvl of paper
year of paper (2007,2009, or 2005)

I want a list of surname first name etc for all students (automatically) with score1, score2 as empty boxes to be filled in by the user so empty spaces are needed. But when I write a query I get only the results from last years tests

ive come up against a wall.

How can I get only empty fields to fill in and how could I then update the tblscores


Can anyone nudge me in the right direction

[pbaldy]

This is flagged as solved; is it? If not, I'd probably run an append query to put the appropriate values into the scores table, then open a form that displayed the newly added records.

[andy49]

Thanks pbaldy.

[pbaldy]

No problem, post back if you get stuck.