Klos, Susan
Susan.Klos at fldoe.org
Sun Jun 8 22:58:37 CDT 2003
No. I have to use the rank function that is used by Excel. -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Sunday, June 08, 2003 8:07 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] super critical:PercentRank function in Access Susan: I don't know about the Worksheet function but can't you rank the numbers in the table by retrieving them with a query and use the ORDER BY clause on that field? HTH is ----- Original Message ----- From: "Klos, Susan" <Susan.Klos at fldoe.org> To: <accessd at databaseadvisors.com> Sent: Sunday, June 08, 2003 4:04 PM Subject: [AccessD] super critical:PercentRank function in Access > Has anyone used Worksheet functions in Access? I am trying to rank a column > of numbers in a table and I have no idea even how to begin. HELP!! Please. > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com