L
Laurel
I don't do a lot of reports, so this may be really simple minded....
I have a report based on a query. The query looks like this:
SELECT tblStudents.id, tblLevels.Levels, tblLevels.Level_Comment,
tblScores.Comments
FROM (tblStudents INNER JOIN tblLevels ON tblStudents.id = tblLevels.id)
LEFT JOIN tblScores ON (tblLevels.id = tblScores.id)
WHERE (((tblScores.Comments) Is Not Null))
ORDER BY tblStudents.id DESC;
.... and when it is executed, I get rows looking something like this
(tblScores is a multiple entry secondary to tblLevels):
[id] [levels] [level_comment] [comments]
1 1 'comment 1' 'another comment'
1 1 'comment 1' 'and yet another commnet'
1 1 'comment 1' 'and on and on ...'
2 3 'comment 2' 'this ones first comment'
2 3 'comment 2' 'the second comment'
3 5 'comment 3' 'the first comment of # 3'
3 5 'comment 3' 'the second comment of #3'
The format of the report looks like this (detail section).
"Student" "Level" "Comments"
[id] [levels] [level_comment]
[comments]
I have put id, levels and level_comment in the "sorting and grouping" list
with "group on" = "each value", but that didn't seem to make any difference.
I was hoping to suppress repeats for the first four fields - but I hadn't
gotten that far.
My problem is that only one row prints per id. So for this query result, I
would get the following:
Student Level Comments
1 1 Comment 1
another comment
2 3 comment 2
the second comment
3 5 comment 3
the first comment of #3
What has happened to the other rows in the query?
I have a report based on a query. The query looks like this:
SELECT tblStudents.id, tblLevels.Levels, tblLevels.Level_Comment,
tblScores.Comments
FROM (tblStudents INNER JOIN tblLevels ON tblStudents.id = tblLevels.id)
LEFT JOIN tblScores ON (tblLevels.id = tblScores.id)
WHERE (((tblScores.Comments) Is Not Null))
ORDER BY tblStudents.id DESC;
.... and when it is executed, I get rows looking something like this
(tblScores is a multiple entry secondary to tblLevels):
[id] [levels] [level_comment] [comments]
1 1 'comment 1' 'another comment'
1 1 'comment 1' 'and yet another commnet'
1 1 'comment 1' 'and on and on ...'
2 3 'comment 2' 'this ones first comment'
2 3 'comment 2' 'the second comment'
3 5 'comment 3' 'the first comment of # 3'
3 5 'comment 3' 'the second comment of #3'
The format of the report looks like this (detail section).
"Student" "Level" "Comments"
[id] [levels] [level_comment]
[comments]
I have put id, levels and level_comment in the "sorting and grouping" list
with "group on" = "each value", but that didn't seem to make any difference.
I was hoping to suppress repeats for the first four fields - but I hadn't
gotten that far.
My problem is that only one row prints per id. So for this query result, I
would get the following:
Student Level Comments
1 1 Comment 1
another comment
2 3 comment 2
the second comment
3 5 comment 3
the first comment of #3
What has happened to the other rows in the query?