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 strongm 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: *

  1. accessSQL

    SQL Error within IIF Function ?

    Hi life forms out there, in an ACCESS mdb we had a SQL statement like this: SELECT XAT.*, GWT.GwtText, XLS.XLSGWTNr, XLS.XLSNr, XLS.XLSLosnummer, XLS.XLSText, IIf([XATTyp]=1 Or [XATTyp]=2 Or [XATTyp]=7,[XATFormelergebnis]*[XATmittel],0) AS XATErgebnis, IIf(VarType([XATXBTNr])>1 And...

Part and Inventory Search

Back
Top