Sum of 2 lines of Count query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Access community,
I am a novice and want the sum of a query that results in
CountID Type
10 1
2 2

I would like to know how to get the sum of 12, preferably as a new field
within that same query, or else in a new query. Thank you in advance.
Mary
 
Just wrap you query in another query

Select Sum([Countid]) as SumOfCountID
From (Select Count([someField]) as CountID from [sometable])
 
You will need another query that uses this query as its recordsource. It
should have only one field, CountID, and be a Totals query using Sum in the
Group by.
 
Sorry, Mary, I really don't know if you can. It might be possible with a
CrossTab query, but I skipped class that day and it is a weak point for me.
 
Hello Access community,
I am a novice and want the sum of a query that results in
CountID Type
10 1
2 2

I would like to know how to get the sum of 12, preferably as a new field
within that same query, or else in a new query. Thank you in advance.
Mary
Click to expand...

Not at all easily. A hairy UNION query might do it.

However, if you just want to *see* these subtotals, consider using a
Form (for onscreen use) or Report (for printing). Base it on this
query and put a textbox on the Form (or Report) footer with a control
source

=Sum([CountID])

John W. Vinson[MVP]
 
Back
Top