Tom Shaw <[EMAIL PROTECTED]> wrote: > Here ya go. > > >Tom Shaw <[EMAIL PROTECTED]> wrote: > >> UPDATE av_summary SET rank=((det*100.0)/(tot)); only sets the > >> first row correctly then all the others have bogus data in rank > > > >That seems wrong. Can you post a sample database that demonstrates > >this behavior? > >
I tried this on the database you sent me. The answers all look right to me. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
