anothet IIF question

[nanang setiawan via AccessMonster.com]

hi all,

i have this record
seq item wh qty
1 abc x -10
2 abc y 10
3 def y -15
4 def x 15


i'd like to manipulate that record to show something like this
seq item whsource wh destination qty
1 abc x y 10
3 def y x 15

any idea for doing this??
i know there's something to do with IIf, but i can not figure out how to read next record and skip it after adding to wh destination field.




many thanks

-nanang-

"always listen to experts. They'll tell you what can't be done, and why.
Then do it.''
-- Lazarus Long

 

[Tom Lake]

i have this record

seq item wh qty
1 abc x -10
2 abc y 10
3 def y -15
4 def x 15


i'd like to manipulate that record to show something like this
seq item whsource wh destination qty
1 abc x y 10
3 def y x 15

any idea for doing this??
i know there's something to do with IIf, but i can not figure out how to
read next record and skip it after adding to wh destination field.

You should probably have just one record for item abc with the fields

Seq Item WhSource WhDest Qty
1 abc x y 10
2 def y x 15

Tom Lake