Access Query - Calc while item code is the same

[Mikki Richard]

My table has item code, item sequence, and then item minimum, base and rate. I want write a query to calc the item charge while the item code is the same. Each item code could have more than one sequence (or tier).

ItemNumber ItemSeq ItemUnit ItemMin ItemBase  Item Rate
F00011       01       10    $75.00   $18.00    $3.30
F00011       02       15     $0.00    $0.00    $2.20
F00011       03      999     $0.00    $0.00    $1.10
F00014       00        1     $0.00   $18.00    $0.00

I'm thinking it should be some kind of "for each" or "do while" statement, but I can't figure it out.

[NeoPa]

I presume [Item Code] and [Item Number] are the same thing, though why on earth you would post it the way you have is completely beyond me. Saving yourself time while upsetting hundreds of people who are just trying to help you seems a strange way to start a question.

Your question is about how you would calculate the [Item Charge] in a query. As you also give no explanation of what calculation should be used (although the values available for use are well detailed - good work on that - Actually, that's why I didn't simply delete the question), I can't see any way I can answer this now.

Why don't you provide the required details for the question and we'll do what we can for you.