Re: Select Max(col name) Expr1000


>I am trying to select a MAX value from a column and I have in the past added
>my own temporary column to return the max value into but I could not get
>that to work. I noticed that the query returned the value into a column
>called expr1000. Does it always return that column name with the max value
No.

You tell the query the new fieldname like this

Select MAX ([Piece Number]) as NewFieldName FROM your table


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages