Management question and Calulations

L

lordjeffj

Calulations with with in a query setting. I have a table or query that has
total payment Line Items for each line item I would like to calulate a roylty
for. I need to wright expression statement that goes and pull a metric rang
of data, so that the amounts fill in after the query Ran.

Royalty: IIf([TEST 2005 to 2006]![Ord Type]="Upgrade" Or [TEST 2005 to
2006]![Ord Type]="contract" Or [TEST 2005 to 2006]![Ord
Type]="Addendum",IIf([Ord Type]<>"Contract",[Timekeeper]<[BO Payment
Chart]![Timekeeper band],[BO Payment Chart]![New]))

it works a little but it only picks up the number that are identified (25
- $4,000.00, 40 - $10,000.00) it does not pick up the in between numbers
(26, 28, 30,) and number that fall after the base number should retrive the
nix down amount ( 27 - $10,000.00)

Please help



Please help
 
Top