Hi

i have a table
with columns

student_number,
test1score,
test1date,
test2score,
test2date,
test3score,
test3date

i need to select the max(test1score) and the corresponding test1date
max(test2score) and corresponding test2date and the max(test3score) and corresponding test3date
all in one single query

also no restrictions on number of times a student takes a test
and test scores and dates can be NULL.

anyone any tips ?

I posted a reply to you in the access forum.