Lookup

[Arlend Floyd]

I have a table "TblRates" Im want to make a calculation on my report based on
this table.

Example:
The report total is $35000 I need it to look in the table and bring back
3.75% so I can make my calculation on my report.

TBlRates
AmtLow AmtHigh CommRate
10001 20000 3.25%
20001 30000 3.50%
30001 40000 3.75%


Thanks
Arlend

 

[Marshall Barton]

I have a table "TblRates" Im want to make a calculation on my report based on
this table.

Example:
The report total is $35000 I need it to look in the table and bring back
3.75% so I can make my calculation on my report.

TBlRates
AmtLow AmtHigh CommRate
10001 20000 3.25%
20001 30000 3.50%
30001 40000 3.75%

Try using a text box expression like:

=DLookup("CommRate". "TblRates", [report total] & " Between
AmtLow And AmtHigh")

 

[Arlend Floyd]

Thanks Marshall it works.

Arlend

I have a table "TblRates" Im want to make a calculation on my report based on
this table.

Example:
The report total is $35000 I need it to look in the table and bring back
3.75% so I can make my calculation on my report.

TBlRates
AmtLow AmtHigh CommRate
10001 20000 3.25%
20001 30000 3.50%
30001 40000 3.75%

Try using a text box expression like:

=DLookup("CommRate". "TblRates", [report total] & " Between
AmtLow And AmtHigh")