Calculating values from fields

[Sam]

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?

 

[Josh Bertsch [MSFT]]

sum(field1[field2 = "true"])

--josh bertsch

 

[Sam]

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?

 

[Sam]

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.

--
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?

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?

 

[Josh Bertsch [MSFT]]

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
"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.

--
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?

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?

 

[Sam]

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.

--josh bertsch

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.

--
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?

:

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?