Using Builder to identify a price in a separate field, if there is a price in that field.

[RobFlott]

My database has a field 'Offer Description' which may or may not include a price, for example $29.99. I have a query where I want to identify the price in a new field called 'Quantity Discount Price'.

Using Builder I tried writing numerous expressions that will result in the 5 or 6 character price (ex $7.99 or $29.99), if there is a price associated with that record in the 'Offer Description' field, but with no luck:

QD Price: IIf([Offer Description] Like '*$*',Right$('$'+5),"")



Can anyone point me in the right direction and where my expression is wrong?

Thank you,

Rob

[June7]

What does 'no luck' mean - error message, wrong result, nothing happens?

QD Price: IIf([Offer Description] Like "*$*", Val(Mid([Offer Description], InStr([Offer Description], "$")+1)), Null)


Recommend no spaces nor punctuation/special characters (underscore only exception) in naming convention.

[orange]

Rob,

Tell us a little more about your application in simple English -no database or jargon. Once readers understand the issue they may provide more focused responses.
Prices are typically numbers that can be added/subtracted etc. Putting such "prices" within text strings does not offer any chance of arithmetic, unless you separate out the "numbers".
Good luck with your project.

[RobFlott]

What does 'no luck' mean - error message, wrong result, nothing happens?

'no luck' meant wrong result.

Your input solved my issue,

Thank you for your help