Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: joellita
  • Content: Threads
  • Order by date
  1. joellita

    IIF Problem (syntax?)

    Ok so this is the part I've done: Profit: IIf ([ExtendedCost]) =0, ([Retail for one Cost]) - ([SingleCost]), IIf ([SingleCost])=Null,([Retail for Multiple Costs]) - ([ExtendedCost])) This is an access query.. Basically I want it to say that if the ExtendedCost value is 0 then do: retail for...

Part and Inventory Search

Back
Top