Trying to get a query to change text

[jonwentz]

I have a report based on a query

and it hase a [Product] and a [Quantity] field

Quantity Product
80 F2 1.25" Fiberglass Sucker Rod
60 F2 1" Fiberglass Sucker Rod
80 1" coupling
60 7/8" coupling

what i am trying to do is multiply the quantity by 37.5 if [Product] equals one of the items that are sold by the foot and leave the other items the same

this is the way it needs to display on the report

Quantity Product_Name
80 (3000') F2 1.25 Fiberglass Sucker Rod
60 (2250') F2 1 Fiberglass Sucker Rod
80 1" coupling
60 7/8" coupling

thanks for any help

 

[neileg]

How do you know the product is sold by the foot? Is it the F2? If so then this should work:

iif(Left([Product_Name],2)="F2", "(" &([Quantity]*37.5) & ") " &[Product_Name], [Product_Name])

 

[jonwentz]

there are about 20 items that i need to do this for

F2 1.25" Fiberglass Sucker Rod
F2 1" Fiberglass Sucker Rod
F2 7/8" Fiberglass Sucker Rod
F2 3/4" Fiberglass Sucker Rod
And so on


other items have F2 in them so i cant just use F2

thanks for any help

 

[neileg]

So I repeat myself, how can you identify the items that are sold by the foot?