L LadyDi Registered User. Local time Yesterday, 19:18 Joined Mar 29, 2007 Messages 894 Feb 7, 2008 #1 I need a query to show me totals, but I just need the totals on one line and not an entire column of totals. Any suggestions?
I need a query to show me totals, but I just need the totals on one line and not an entire column of totals. Any suggestions?
mhartman Dr. Data Local time Yesterday, 19:18 Joined Jun 5, 2006 Messages 442 Feb 7, 2008 #2 Hello: SELECT Sum(YourTableName.YourField2SumName) AS SumOfYourField2SumName FROM YourTableName; Regards
Hello: SELECT Sum(YourTableName.YourField2SumName) AS SumOfYourField2SumName FROM YourTableName; Regards