DavidL:

The First() function returns the first value found in a field of the dataset. Refer to the Books Online for more information.

I hope this helps.

Regards!

Perhaps is not "commercially" convenient for Microsoft to make public such a mistake. However, as Steve said, we've all done mistakes before; and admiting you made a mistake and working...

Hey, this one was easy...

"You will soon realize that I have not so far insulted anybody..."

Really? You called me "liar", folk.

Thanks for your OPINION Cimode. However I think you should take a look to the books online and figure out how SUM works.

select sum(field1 + field2) from table1

--> it returns...