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 Chriss Miller 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: writersoon
  • Content: Threads
  • Order by date
  1. writersoon

    Long,long IIf statement

    Does anyone know how to make these 3 IIf statements into one? I am trying to put it all in one column and i keep recieving errors when i make input all 3 statments into 1 and change the query to a make table query. Thanks in advance... SELECT p.*, IIf([POType]="PO" And [NonStock]="N","NS"...
  2. writersoon

    Confused on a confusing iif statement

    I've created a db with 1 update table and 1 maketable query. I ve created an iif statement but its not long enough for the info i need. The statement works, but where do i fit the rest in? SELECT IIf([PO Type]="BO","Blkt Order",IIf([PO Type]="RM","PORM",IIf([PO Type]="WT","WHS...

Part and Inventory Search

Back
Top