> 01/01/03 ABC 20488 X03-1000 $500 > 07/20/04 DEF 20488 X04-1431 $1000 > > I am printing invoice X04-1431 > The print command is PRINT INV_DETAIL WHERE INVNBR = > 'X04-1431' OPTION > PRINTER.
In that case, the row with the $500 data should never be used by the report. Just out of curiosity, why did you title your post "Lookup Dilemma"? As you've described it, the report should not require a look up, at least not for the dollar amount. If you _are_ using a lookup, check the logic involved there, it might indicate why the wrong data is getting loaded. -- Larry
