Lookup Problem

[n107jkx]

I have been trying to use the DLOOKUP command in a query, but i am not sure if this is the right way to approach a problem.

I have a table which lists a 'Students ID', 'Test ID' and the mark scored by the student in that test ('Mark'). I would like to create a query that will help me make a tabular-style report, listing the students name, their score in test one, their score in test two and their score in test three (i have, and will only have, three tests).

To lookup the mark scored in test one i have been trying to use a DLOOKUP expression in that query, but it gives me lots of repeated gobbldy-gook, with each person having the same score.

I think i am using the formula right, so any suggestions on how to solve theproblem would be much appreciated.

 

[SydneyGeek]

Have you tried a crosstab? Student = RowHeader, TestID=ColumnHeader, Mark=Value, aggregated by Sum. That will give one row per student, test results across the page.
Use that as the basis of the report.

Denis

 

[n107jkx]

Great

That was just what i was looking for

Thanks very much