Wednesday, December 12, 2012 10:47 PM
I am trying to query a single table and return two sets of data into two columns for a report.
the table in question (tblReviewComments) looks something like this:
Key - ReviewCommentTypeID - PlainText
001 - 15 - "Text of Comment type 1"
002 - 10 - "Text of Commen type 2"
I am trying to return a distinct colum for each type of comment.
The complete query as is can be filtered to show any of the comment types.
INNER JOIN tblReviewBankInfo
ON tblReviewBorrower.ReviewBorrowerId = tblReviewBankInfo.ReviewBorrowerId
INNER JOIN tblReviewNote
ON tblReviewBorrower.ReviewBorrowerId = tblReviewNote.ReviewBorrowerId
INNER JOIN tblReview
ON tblReviewBorrower.ReviewKey = tblReview.ReviewKey AND tblReviewNote.ReviewKey = tblReview.ReviewKey
INNER JOIN tblReviewComment
ON tblReviewBorrower.ReviewBorrowerId = tblReviewComment.ReviewBorrowerId AND tblReview.ReviewKey = tblReviewComment.ReviewKey
- Edited by Toby Ellis Wednesday, December 12, 2012 10:47 PM
Thursday, December 13, 2012 8:56 AMModerator
You can create two datasets with different where clause base on you requirement in the query, in this case you can get two different sets. And then you can use LookUp function to display data in different datasets. For more information about LookUp function, please see:
If I have anything misunderstood, please point it out and elaborate what you wan to achieve so that we can make further analysis.
If you have any feedback on our support, please click here.
TechNet Community Support
Tuesday, December 18, 2012 4:25 PM
That did the trick. Thank you so much!