Agree with first response, you best best is to create a function like
below:
************************************************** ****
Public Function CalcCharge(strService as string, strPkgType as string,
sglSTC as currency) as currency

if strService = "Express" then
select case strPkgType
case "LETTER"
CalcCharge = sglSTC-(sglSTC* .422)
case "Box"
CalcCharge = sglSTC-(sglSTC * .392)
Case "PAK"
CalcCharge = sglSTC-(sglSTC * .035)
end select
elseif strService = "Ground" then
select case strPkgType
case "Letter"
CalcCharge = ------------
case "Box"
CalcCharge = ____________
Case "Pak"
CalcCharge =____________
end select
else strService = International
Select Case strPkgType
Case.......
(go thru the 3 package types)

end select
end if

end function
*********************************
Then in your query, put in a column CalcCharge([Service Fld Name],
[package type field name],[Shipment Transportation Charge field name])




Bob wrote: