Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
unequal rows
- Thread starter leburg
- Start date
Need more info. Like what you are trying to do.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"What version of URGENT!!! are you using?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"What version of URGENT!!! are you using?
If you take data from Table A and Table B, your 'detail lines' are the records that occur in both. SOmething that occurs five times in A and once in B will result in 5 detail lines with the same value of B. If B had occurences, you'd have ten, five for each B.
Often it's best to group and suppress detail lines to get rid of the duplicates/
If the value might be missing from B, a 'left outer' will give you occurences of A not in B. This won't work if you also select for B, unless the selection allows for null values.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
Often it's best to group and suppress detail lines to get rid of the duplicates/
If the value might be missing from B, a 'left outer' will give you occurences of A not in B. This won't work if you also select for B, unless the selection allows for null values.
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 - Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question