Unmatched Records Query

[Former Member]

Hi Folks - I have a table of students and a table of student test scores. I want to create a query that lists students that do not have a score. Do-able?

Michael

[Former Member]

Hi,

You can write a function like this in a variable.

let the variable be ABC.

ABC = [student] where(isnull([test score])), where [student] is the dimension and [test score] is the key figure.This will bring up the students with no Test Scores.

Hope this will help you.

Regards,

ArunKG

[Former Member]

Hi Folks - Never mind ... got turned on to combined queries.