Calculating values from fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 21 Oct 2004 13:09 GMT

I have access-database with table. I want to sum the "field1" values if
record's another "field2" value is "true". How is this possible?

Signature

-Sam

Reply to this Message

Josh Bertsch [MSFT] - 22 Oct 2004 00:40 GMT

sum(field1[field2 = "true"])

--josh bertsch

>I have access-database with table. I want to sum the "field1" values if
> record's another "field2" value is "true". How is this possible?

Reply to this Message

Sam - 22 Oct 2004 14:21 GMT

Thanks that information will help me go forward. Final thing, is it possible
to save sum to field3?

> sum(field1[field2 = "true"])
>
> --josh bertsch
>
> >I have access-database with table. I want to sum the "field1" values if
> > record's another "field2" value is "true". How is this possible?

Reply to this Message

Greg Collins [MVP] - 22 Oct 2004 19:22 GMT

Set the formula Josh provided you as the default formula value for field3.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

Thanks that information will help me go forward. Final thing, is it possible
to save sum to field3?

"Josh Bertsch [MSFT]" wrote:

> sum(field1[field2 = "true"])
>
> --josh bertsch
>
> >I have access-database with table. I want to sum the "field1" values if
> > record's another "field2" value is "true". How is this possible?

Reply to this Message

Sam - 25 Oct 2004 12:59 GMT

It seems that formulas can only be set in "expression box" but the condition
"if true won't work there". I can see from manual that there should be an
insert formula button(fx) when opening properties, but in this version there
isn't.

> Set the formula Josh provided you as the default formula value for field3.
>
[quoted text clipped - 9 lines]
> > >I have access-database with table. I want to sum the "field1" values if
> > > record's another "field2" value is "true". How is this possible?

Reply to this Message

Josh Bertsch [MSFT] - 26 Oct 2004 01:58 GMT

SP1 is the only version that has calculations implemented. You will have to
download SP1 to take advantage of all of the new features.

--josh bertsch

> It seems that formulas can only be set in "expression box" but the
> condition
[quoted text clipped - 19 lines]
>> > >if
>> > > record's another "field2" value is "true". How is this possible?

Reply to this Message

Sam - 27 Oct 2004 15:41 GMT

Thanks to every advises, they have helped me almost complete the task. Just
tiny problem remains. Calculations between two field works perfectly. The
problem appears when I try to sum these different record's calculated sums
together. I have tried to do it as text box and expression box. Both works,
but it sums only the first record's calculated value. This way the formula
has to be a default value of field which is part of the database-table. Is
there anymore help available?

> SP1 is the only version that has calculations implemented. You will have to
> download SP1 to take advantage of all of the new features.
[quoted text clipped - 24 lines]
> >> > >if
> >> > > record's another "field2" value is "true". How is this possible?

Reply to this Message

Sophie Chaouche - 09 Mar 2005 13:44 GMT

Hi,

Did you find the solution? I'm facing the same problem and I would
appreciate to know how you managed to do it.

Thank you,
Sophie

Reply to this Message