Minimum Fees

[Guest]

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

 

[Guest]

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

Where is the code? is it the control source of a text box?

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

Yes

Where is the code? is it the control source of a text box?

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

:

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

What is Fee!Group?
What is [Fee]

Yes

Where is the code? is it the control source of a text box?

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

:

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

:

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

The fee is a projected saving value times a fee percentage like 2,290 x .12 =
$275 however the calculation is done in excel before the table is imported,
so it is just a dollar amount. What I am trying to do is say if the company
is in group 15 they have a minimum fee of $25, so if the "Fee" is in Group 15
and <25, 25. The remaining groups all have a minimum fee of $75.

=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

What is Fee!Group?
What is [Fee]

Yes

Where is the code? is it the control source of a text box?

:

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

:

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

:

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

What I am asking is are they fields in the report's record source or are they
text boxes on the report?

The fee is a projected saving value times a fee percentage like 2,290 x .12 =
$275 however the calculation is done in excel before the table is imported,
so it is just a dollar amount. What I am trying to do is say if the company
is in group 15 they have a minimum fee of $25, so if the "Fee" is in Group 15
and <25, 25. The remaining groups all have a minimum fee of $75.

=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

What is Fee!Group?
What is [Fee]

Yes

:

Where is the code? is it the control source of a text box?

:

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

:

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

:

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

Sorry. The fee is a Text Box and the Group codes are from a field in the
access table for the company.

What I am asking is are they fields in the report's record source or are they
text boxes on the report?

The fee is a projected saving value times a fee percentage like 2,290 x .12 =
$275 however the calculation is done in excel before the table is imported,
so it is just a dollar amount. What I am trying to do is say if the company
is in group 15 they have a minimum fee of $25, so if the "Fee" is in Group 15
and <25, 25. The remaining groups all have a minimum fee of $75.

=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

What is Fee!Group?
What is [Fee]



:

Yes

:

Where is the code? is it the control source of a text box?

:

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

:

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

:

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

GOT IT!! Thanks Klatuu


=IIf([Group_code]="15",IIf([Fee]<=25,25,[Fee]),IIf([Fee]<=75,75,[Fee]))

 

[Guest]

Okay, there is the problem. I looks like you are trying to find a field
named Group_code in a table named Fee. This is not going to work this way.
The best way would be to include it in the report's record source.
Hopefully, the record source is a query and there is some relation between
the data you are using and the correct record in the Fee table. If so, you
could add the Fee table to your query and joing in on the related field.

If that is not possible, then you will have to use a DLookup to find the
value in the correct record.

In either case, you will need to create a text box on the report to carry
that value. If you don't want it to print, make its Visible property false.
Then reference the text box in your calculation.

Sorry. The fee is a Text Box and the Group codes are from a field in the
access table for the company.

What I am asking is are they fields in the report's record source or are they
text boxes on the report?

The fee is a projected saving value times a fee percentage like 2,290 x .12 =
$275 however the calculation is done in excel before the table is imported,
so it is just a dollar amount. What I am trying to do is say if the company
is in group 15 they have a minimum fee of $25, so if the "Fee" is in Group 15
and <25, 25. The remaining groups all have a minimum fee of $75.

:

=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

What is Fee!Group?
What is [Fee]



:

Yes

:

Where is the code? is it the control source of a text box?

:

Hi,

I rewrote using your criteria:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee])) and
now I get an #ERROR in the report print preview. Could it have something to
do with the extra = sign?

:

When using the IIF, you don't put the something = something in it. It
returns one of two values depending on the condition argument:
=IIf(Fee!Group_code="15",IIf([Fee]<25,25,[Fee]),IIf([Fee]<75,75,[Fee]))

:

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))

 

[Guest]

Great,
Should have read this post before I answered the last.

Do others a favor, please. Rate the post so others searching for a similar
answer will be able to identify it as an answered question.

GOT IT!! Thanks Klatuu


=IIf([Group_code]="15",IIf([Fee]<=25,25,[Fee]),IIf([Fee]<=75,75,[Fee]))

The fee is calculated in excel, brought over into an access report, and the
field is displayed on a report. I am trying to apply criteria that would set
a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee.

Can this be written in the Control Source of the report? And, why isn't it
working?

=IIf(Fee!Group_code="15",IIf([Fee]<=25,[Fee]=25,[Fee]),IIf([Fee]<=75,[Fee]=75,[Fee]))