D digs Registered User. Local time Today, 18:55 Joined Aug 16, 2004 Messages 20 Jan 25, 2005 #1 I've got a query that has fields of pay no, name & hours. There are numerous hours for a pay no what i would like to do is put a running total for pay no in acsedning order for hours. Can anyone help.
I've got a query that has fields of pay no, name & hours. There are numerous hours for a pay no what i would like to do is put a running total for pay no in acsedning order for hours. Can anyone help.
neileg AWF VIP Local time Today, 18:55 Joined Dec 4, 2002 Messages 5,975 Jan 25, 2005 #2 So what is it you want? Do you want to total by pay number and then sort the totals? In that case create a totals query and apply a sort. Or what?
So what is it you want? Do you want to total by pay number and then sort the totals? In that case create a totals query and apply a sort. Or what?