Jim Lawrence (AccessD)
accessd at shaw.ca
Mon Jun 9 00:30:26 CDT 2003
Hi Susan: Here is an example of a ranking system created without access to Excel's ranking function: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20325878.ht ml HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Klos, Susan Sent: Sunday, June 08, 2003 8:59 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] super critical:PercentRank function in Access 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com