Lookup

  • Thread starter Thread starter Arlend Floyd
  • Start date Start date
A

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
 
Arlend said:
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%
Click to expand...


Try using a text box expression like:

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

Arlend

Marshall Barton said:
Arlend said:
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%
Click to expand...


Try using a text box expression like:

=DLookup("CommRate". "TblRates", [report total] & " Between
AmtLow And AmtHigh")
Click to expand...
 
Back
Top