Ben: Interesting thought... I just tried my simple 2-column insert from my just-posted email to switch the order so that the variable is FIRST rather than last and that didn't make a difference...
Karen > I'm working with a very faint memory, but try changing the order such > that the LAST value inserted cannot be null or empty. > > Like: INSERT INTO sales + > (invoiceno, trantime, accountno, billaccount, brate, > invoiceno, trandate) + > SELECT invoiceno, .#TIME, accountno, .vmacctno, > .vBillRate, .#DATE + > FROM tempsales WHERE ..... > > Ben
