Count/Sum or Ave all rows of a field

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

Hi all, i am a newbie to this game and want to know if it is possible
with VBA to count up all the rows for a specific field for a table or
average or sum ?
If it is possible, could you help me with some code please.

I add up fields succesfully with the following :-

myLcPo = Nz(DSum("[Total LC PO's]", _
"tblTotalLcPO's", "[ByrName] = ""Kufner"""), 0) + Nz(DSum("[Total LC
PO's]", "tblTotalLcPO's", "[ByrName] = ""Steyn"""), 0)
 
Les

No code needed. Open a new query in design mode, add the field(s), select
the "Totals" query (toolbar button). Use "Sum" to aggregate.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

totals for multiple fields 1
Pivot table calculated field Count(field) / sum(field) 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to direct Dsum() to sum dbs2.Tbl1 not dbs1.Tbl1 data 5
summing values in each record (summing across rows) 2
DSum update query with multiple fields 0
Problem with OLE server or Activex control-URGENT 1
DSum and date as criteria 3

Back
Top