Actually... Nevermind my previous response. I knew it was something

obvious. I was assuming that I knew what the variable number was and that

it was much lower than what I was receiving.

Never assume. Never assume. Never assume.

Incidentally, the parentheses do indeed work -- but I'm sure you knew that.

--Brad

> -----Original Message-----

> From: Ed Leafe

> Sent: Wednesday, July 12, 2000 2:22 PM

>

> Use parentheses.

>

> SELE TOP (parenttable.nQty) ;

> fld1, fld2, fld3 ;

> FROM childtable ;

> ORDER BY 1