What would be most helpful to you would be to attach sample QVW on this one, so folks can see what you currently have for data model etc. to try to figure out why it is doing what it is doing. Very difficult to say much otherwise with what you have provided for review.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.