Count number of rows in a query.

[jimmy_pun1]

i've got a query result of

Donation Date DonorID
11/1/2006 5
11/1/2006 12
11/3/2006 15
11/4/2006 30
11/4/2006 6

what i want is a third column to do a simple numeric count.

a 3rd column with

Donation Date DonorID numeric count
11/1/2006 5 1
11/1/2006 12 2
11/3/2006 15 3
11/4/2006 30 4
11/4/2006 6 5


i don't need number of counts on a specific date (for example 2 on
11/1/2006 and 2 on 11/4/2006 .)

just a linear 1,2,3,4,5,6 count, so i know how many donations there are
up to a certain date.

i know this is probably very easy to do... but im new at this access
stuff and im stuck.

 

[Van T. Dinh]

See the sample database from Stephen Lebans' Web site:

http://www.lebans.com/rownumber.htm

 

[jimmy_pun1]

thnx for the quick response
i entered Expr1: Serialize("3","DonationID",[DonationID]) into the
field box.
("3" being the name of my query and "DonationID" being what i want to
count)

when i try and open it, a message pops up saying

undefined function "serialize" in expression.

 

[aaron.kempf]

if you were just using Access Data Projects; you could use the RANK
function

MDB is obsolete; it's pointless, unstable and insecure

-Aaron

thnx for the quick response
i entered Expr1: Serialize("3","DonationID",[DonationID]) into the
field box.
("3" being the name of my query and "DonationID" being what i want to
count)

when i try and open it, a message pops up saying

undefined function "serialize" in expression.

See the sample database from Stephen Lebans' Web site:

http://www.lebans.com/rownumber.htm

 

[Van T. Dinh]

Did you copy the Module "ProdGetLineNumber" from the sample database into
your database???

 

[jimmy_pun1]

Got it

thnx for all your help.

 

[Joseph Meehan]

if you were just using Access Data Projects; you could use the RANK
function

MDB is obsolete; it's pointless, unstable and insecure

-Aaron

It seems Aaron got confused again. He really meant to say " Aaron MDB
is obsolete; it's pointless, unstable and insecure"