N Naka Registered User. Local time Today, 15:35 Joined Jul 27, 2007 Messages 24 Aug 2, 2007 #1 is there a way to total up the number of rows i have in a table/query and have that number show up on a new seperate row kinda like the way sums are shown in msexcel. using access2003 btw, thanks
is there a way to total up the number of rows i have in a table/query and have that number show up on a new seperate row kinda like the way sums are shown in msexcel. using access2003 btw, thanks
Guus2005 AWF VIP Local time Tomorrow, 00:35 Joined Jun 26, 2007 Messages 2,636 Aug 2, 2007 #2 something like Code: Select Amount, DSUM("Amount", "Account") as TotalAmount From Account Which gives you a column with the total amount of the account table. HTH
something like Code: Select Amount, DSUM("Amount", "Account") as TotalAmount From Account Which gives you a column with the total amount of the account table. HTH
N Naka Registered User. Local time Today, 15:35 Joined Jul 27, 2007 Messages 24 Aug 2, 2007 #3 do i use that code as a module? sorry im new at this
