List Comments Depending on Characteristic

[Dave177]

Hi there,

I have a query with the following fields:

[Comment] eg. Food, Staff, Facilities
[PositiveNegative] either positive or negative.
(and others not relevant to this problem)

I am trying trying to set up 2 controls in the report, one which will list the comments that are positive and one that will list the comments that are negative. It sounds easy I know but can't seem to do it properly.

I tried setting up a 2 new fields in the query:
Positives: IIF(([PositiveNegative]) like "Positive",[Comment])
and
Negatives: IIF(([PositiveNegative]) like "Negative", [Comment])

However this leaves blanks eg. if the comment is positive the will be an empty space on the negative list. How do I create a positive comment list and a negative comment list with no blanks.

Any help would be great.
David

 

[GingerR]

Make two subreports, one with the recordsource of "positives" and one with the recordsource of "negatives", then embed the two subreports in your report next to each other.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Dave177]

Thanks GingerR!