Its simply looking at line 26 for the invoice number and inputting it in a table. but on some invoives line 26 is blank, so i need it to check line 27, but only if line 26 is blank. at the minute its checking both lines and inputting info from both lines
>This doesn't sound like a very robust method. > >Are you able to provide sample invoice(s)? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4