Sum by a certain group by only for certain criteria of another fie

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

Guest

I have a grouping of information and that grouping is the information that I
want to sum by. The catch is that within that grouping I have another field
called "Status". I only want to sum the records that have a certain value
for the "Status" field. Is there a way to do that?

Thanks in advance,
John
 
John said:
I have a grouping of information and that grouping is the information
that I want to sum by. The catch is that within that grouping I have
another field called "Status". I only want to sum the records that
have a certain value for the "Status" field. Is there a way to do
that?

Thanks in advance,
John
Click to expand...
If you want to show everythiung and only the total for the records that have
Status = "fine" then
make a calculated field = iif([status] = "Fine";Yousum;"")


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Back
Top