Calculation

[mavis]

Hi All,

I need to 3 field in the report, "ClaimAmount", "DeductibleAmount" and
"Exposure".
In the Exposure field it will need to dispplay:
~ Display "ClaimAmount" if ClaimAmount is lesser than DeductibleAmount
~ Display "DeductibleAmount" if ClaimAmount is more or equal than
DeductibleAmount

How can have this to be done in the report?
please help me.
Thanks!

 

[Keven Denen]

Hi All,

I need to 3 field in the report, "ClaimAmount", "DeductibleAmount" and
"Exposure".
In the Exposure field it will need to dispplay:
~ Display "ClaimAmount" if ClaimAmount is lesser than DeductibleAmount
~ Display "DeductibleAmount" if ClaimAmount is more or equal than
DeductibleAmount

How can have this to be done in the report?
please help me.
Thanks!

Set the control source of a text box on the report to: =iif
(ClaimAmount<DeductibleAmount,"Claim Amount","Deductible Amount")

This is if you want the field to display the text Claim Amount and
Deductible Amount. If you want the actual values of the claim or
deductible amount, just take the " out and remove the spaces.

Keven Denen

 

[mavis]

Hi Keven,

Thanks, it works great. I have another problem.

I will like to sum up = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") as Exopsuretxt and i tried the code below.

=SUM([Exopsuretxt])

When i try to run the report it prompt me to enter Exopsuretxt.

 

[NevilleT]

Hi Mavis

An easier way is to put the calculation in the query and give it a name such
as

DisplayAmount: IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount")

You can then use =Sum(DisplayAmount)

Neville Turbit
www.projectperfect.com.au

Hi Keven,

Thanks, it works great. I have another problem.

I will like to sum up = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") as Exopsuretxt and i tried the code below.

=SUM([Exopsuretxt])

When i try to run the report it prompt me to enter Exopsuretxt.

Set the control source of a text box on the report to: =iif
(ClaimAmount<DeductibleAmount,"Claim Amount","Deductible Amount")

This is if you want the field to display the text Claim Amount and
Deductible Amount. If you want the actual values of the claim or
deductible amount, just take the " out and remove the spaces.

Keven Denen

 

[mavis]

Hi,

I place the below code in the contro source of the text box but it show erro
ExposureAmount:IIf([ClaimedAmounttxt]>=[CargoDeductible],[CargoDeductible],[ClaimedAmounttxt])

"Invalid Control Property"

Hi Mavis

An easier way is to put the calculation in the query and give it a name such
as

DisplayAmount: IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount")

You can then use =Sum(DisplayAmount)

Neville Turbit
www.projectperfect.com.au

Hi Keven,

Thanks, it works great. I have another problem.

I will like to sum up = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") as Exopsuretxt and i tried the code below.

=SUM([Exopsuretxt])

When i try to run the report it prompt me to enter Exopsuretxt.

Hi All,

I need to 3 field in the report, "ClaimAmount", "DeductibleAmount" and
"Exposure".
In the Exposure field it will need to dispplay:
~ Display "ClaimAmount" if ClaimAmount is lesser than DeductibleAmount
~ Display "DeductibleAmount" if ClaimAmount is more or equal than
DeductibleAmount

How can have this to be done in the report?
please help me.
Thanks!

Set the control source of a text box on the report to: =iif
(ClaimAmount<DeductibleAmount,"Claim Amount","Deductible Amount")

This is if you want the field to display the text Claim Amount and
Deductible Amount. If you want the actual values of the claim or
deductible amount, just take the " out and remove the spaces.

Keven Denen

 

[NevilleT]

Hi Mavis

Should have looked more closely rather than cut and paste. You need to put
in the table field name, not the textbox name. For example if
ClaimedAmounttxt has the field ClaimedAmount, replace ClaimedAmounttxt in the
query formula with ClaimedAmount. In other words use the field names as you
see them in the query rather than the textbox names on the form.

Neville Turbit
www.projectperfect.com.au

Hi,

I place the below code in the contro source of the text box but it show error
ExposureAmount:IIf([ClaimedAmounttxt]>=[CargoDeductible],[CargoDeductible],[ClaimedAmounttxt])

"Invalid Control Property"

Hi Mavis

An easier way is to put the calculation in the query and give it a name such
as

DisplayAmount: IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount")

You can then use =Sum(DisplayAmount)

Neville Turbit
www.projectperfect.com.au

Hi Keven,

Thanks, it works great. I have another problem.

I will like to sum up = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") as Exopsuretxt and i tried the code below.

=SUM([Exopsuretxt])

When i try to run the report it prompt me to enter Exopsuretxt.




:

Hi All,

I need to 3 field in the report, "ClaimAmount", "DeductibleAmount" and
"Exposure".
In the Exposure field it will need to dispplay:
~ Display "ClaimAmount" if ClaimAmount is lesser than DeductibleAmount
~ Display "DeductibleAmount" if ClaimAmount is more or equal than
DeductibleAmount

How can have this to be done in the report?
please help me.
Thanks!

Set the control source of a text box on the report to: =iif
(ClaimAmount<DeductibleAmount,"Claim Amount","Deductible Amount")

This is if you want the field to display the text Claim Amount and
Deductible Amount. If you want the actual values of the claim or
deductible amount, just take the " out and remove the spaces.

Keven Denen

 

[mavis]

Hi,

Don't really understand what you mean.
care to explain?

Hi Mavis

Should have looked more closely rather than cut and paste. You need to put
in the table field name, not the textbox name. For example if
ClaimedAmounttxt has the field ClaimedAmount, replace ClaimedAmounttxt in the
query formula with ClaimedAmount. In other words use the field names as you
see them in the query rather than the textbox names on the form.

Neville Turbit
www.projectperfect.com.au

Hi,

I place the below code in the contro source of the text box but it show error
ExposureAmount:IIf([ClaimedAmounttxt]>=[CargoDeductible],[CargoDeductible],[ClaimedAmounttxt])

"Invalid Control Property"

Hi Mavis

An easier way is to put the calculation in the query and give it a name such
as

DisplayAmount: IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount")

You can then use =Sum(DisplayAmount)

Neville Turbit
www.projectperfect.com.au

:

Hi Keven,

Thanks, it works great. I have another problem.

I will like to sum up = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") as Exopsuretxt and i tried the code below.

=SUM([Exopsuretxt])

When i try to run the report it prompt me to enter Exopsuretxt.




:

Hi All,

I need to 3 field in the report, "ClaimAmount", "DeductibleAmount" and
"Exposure".
In the Exposure field it will need to dispplay:
~ Display "ClaimAmount" if ClaimAmount is lesser than DeductibleAmount
~ Display "DeductibleAmount" if ClaimAmount is more or equal than
DeductibleAmount

How can have this to be done in the report?
please help me.
Thanks!

Set the control source of a text box on the report to: =iif
(ClaimAmount<DeductibleAmount,"Claim Amount","Deductible Amount")

This is if you want the field to display the text Claim Amount and
Deductible Amount. If you want the actual values of the claim or
deductible amount, just take the " out and remove the spaces.

Keven Denen

 

[NevilleT]

Hi Mavis

What are the field names for the claim amount and deductable amount? What
are they called in the table?

Hi,

Don't really understand what you mean.
care to explain?

Hi Mavis

Should have looked more closely rather than cut and paste. You need to put
in the table field name, not the textbox name. For example if
ClaimedAmounttxt has the field ClaimedAmount, replace ClaimedAmounttxt in the
query formula with ClaimedAmount. In other words use the field names as you
see them in the query rather than the textbox names on the form.

Neville Turbit
www.projectperfect.com.au

Hi,

I place the below code in the contro source of the text box but it show error
ExposureAmount:IIf([ClaimedAmounttxt]>=[CargoDeductible],[CargoDeductible],[ClaimedAmounttxt])

"Invalid Control Property"

:

Hi Mavis

An easier way is to put the calculation in the query and give it a name such
as

DisplayAmount: IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount")

You can then use =Sum(DisplayAmount)

Neville Turbit
www.projectperfect.com.au

:

Hi Keven,

Thanks, it works great. I have another problem.

I will like to sum up = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") at the end of the report. how can i do that.
I name the field for = IIF([ClaimAmount] < [DeductibleAmount], "Claim
Amount", "Deductible Amount") as Exopsuretxt and i tried the code below.

=SUM([Exopsuretxt])

When i try to run the report it prompt me to enter Exopsuretxt.




:

Hi All,

I need to 3 field in the report, "ClaimAmount", "DeductibleAmount" and
"Exposure".
In the Exposure field it will need to dispplay:
~ Display "ClaimAmount" if ClaimAmount is lesser than DeductibleAmount
~ Display "DeductibleAmount" if ClaimAmount is more or equal than
DeductibleAmount

How can have this to be done in the report?
please help me.
Thanks!

Set the control source of a text box on the report to: =iif
(ClaimAmount<DeductibleAmount,"Claim Amount","Deductible Amount")

This is if you want the field to display the text Claim Amount and
Deductible Amount. If you want the actual values of the claim or
deductible amount, just take the " out and remove the spaces.

Keven Denen

 

[niki4152]

Calculator is the most perfect program in the world!