[AccessD] super critical:PercentRank function in Access

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


More information about the AccessD mailing list