Posted by Jorgen [DK/2600] on 02/20/07 13:37

Ah.. this one is actually a bit more complex.

My problem is that in a amount field I have both % and Quantity mixed
together. So the formula should check the "format" column for the amount
field, if the format columns contains "%" it return the value - if not, i
writes zero in my expression.

Logical ?

Regards
Jorgen
"Jorgen [DK/2600]" <nyhedsgruppe_hejhej_@gmail.com> wrote in message
news:45daf1ca$0$90275$14726298@news.sunsite.dk...
> Hi,
>
> how do I do a simple formula, which will search a field for special
> characters and return a value.
>
> If it finds "%" - it returns 1
> else
> If it finds "?" it returns 2
>
> end
>
> If this is the incorrect newsgroups, please direct me to the correct one
>
> regards Jorgen
>
>
>

• Next in forum: Re: Stored procedure
• Prev in forum: Re: Function to return "remaining" of field after it finds a character in the field.
• Thread view: Re: Simple function for returning a character based on search criteria..

[Reply to this message]