Greetings, I do not understand why you want to do record numbering in your query. This is usually done on the report. The below link will give you directions on how to do this.
http://office.microsoft.com/en-us/assistance/HP051873831033.aspx Regards Glenn P. Jones IHS -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of niroo_it Sent: Wednesday, 14 September, 2005 3:50 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] row number for query result Hello I want to have a row number field in my query,because of filter or group by in query the record autonumber is not the right order in query result. So how I should write an expresion to have a serial sequential counter for each exracted record? best regards Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
