Craig Farrell (2/17/2011)
Can you post the ddl and some sample data that would provide us the background for what you're looking to generate:
qry_id_2combo hic_numberqry_1&2 123456789A
qry_1&2 987654321A
qry_1&3 456789123B
We're guessing as to what the source data looks like exactly and that's not helping. See the first link in my sig if you'd like some assistance with that.
Sample starting data:
hic_numberqry_id
00005A 9130813
00005A 9130850
00010A 9130813
00010A 9130850
00010A 915216
00010A 915416
00021A 9130813
00021A 9130850
The end result of this sample would be:
hic_number qry_2combo_id
00005A 9130813+9130850
00010A 9130813+9130850
00010A 9130813+915216
00010A 9130813+915416
00010A 9130850+915216
00010A 9130850+915416
00010A 915216+915416
00021A 9130813+9130850