RE: IIf to return a formula or field

Is the datatype for the [price] field a number field?

"waterbug" wrote:

> I do not have any problems getting the function to give me a text answer but
> I need something like this IIf([machinestep]<140, [price]/2, [price]). This
> was obviously not working. If the data in the field [machinestep] is less
> than 140 then I want the answer to be [price] divided by 2, or the data that
> is in the [price] field if it is not less than 140. I do not have a problem
> with getting the first part of the string to give me "text", "text1" but not
> the other way. Thanks for any advice!
.

Relevant Pages

  • RE: IIf to return a formula or field
    ... "waterbug" wrote: ... the [price] field is numeric ... Thanks for any advice! ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Shopping cart not reading size from datatype "text" if it is a nu.
    ... I have a paypal shopping cart that gets adds items from an access database. ... I have a size column in datatype "text". ... to buy something that is a text size the correct corresponding price goes ... for the first size is associated with all of the sizes for that product. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Converting decimal type to double
    ... and then want to reassign it to the value of a ... double datatype "dblTotalVolume", but I get an error "cannot implicitly ... decimal price; ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: IIf to return a formula or field
    ... "KARL DEWEY" wrote: ... > Is the datatype for the [price] field a number field? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: mdx: last valid price
    ... You can do this using a recursive calculation, it might take a while to ... Note that the member refers to itself in the formula, ... If the price did not change in ... > if the Price is not null, show me exactly this value, else show the prev not ...
    (microsoft.public.sqlserver.olap)
Loading