Hi List, I'm making a view. I need to add an incremental number value in a new field (like a row number or Identity) to the final result set - a unique sequential ID I can group by in a second query done on the view. I understand how to make a calculated field in a view. But I don't know how to make a calculated field that is an incremental number based on the final dataset order. Any ideas? Palyne P.S. I am wandering the grand chasm between Forta's two CF books. Does anyone have ideas for other books that might address that CF middle ground? ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
