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 dencom 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: thart21
  • Content: Threads
  • Order by date
  1. thart21

    Sum two fields - IIf statment applies to one

    Hi, I am trying to Sum two fields in my query with an IIf statement that only applies to one of the fields. I keep getting syntax errors and can't figure it out. Calc Rjct Qty: Sum(([OM Rjct Qty],IIf([Rjct Sched Rsn Cd] In ('Z4','Z5','Z6','Z7','Z8'))+[Uncnfm Qty],0)) Want to Sum OM Rjct Qty...
  2. thart21

    Duplicate data in one field in query

    Does anyone know what the cause of this may be? I am joining 2 tables with the following fields and data: ModelNo SONo SO_Line_No OrderQty LateQty ProcessDt ABC 123 10 350 25 4/15/2011 ABC 123 10 50 0 4/20/2011 I am pulling all but LateQty from Table1 and LateQty from Table2. I join my 2...
  3. thart21

    Combine records in query

    I'm completely lost on this one. I am querying from linked Oracle tables and cannot change any of the data. I am grouping by "Prod_Code". The problem is that I have one field in my table that may or may not have data, "Country". What I am getting is one record for each "Prod_Code" that does...
  4. thart21

    Crosstab query and create new query

    Does anyone know why Access 2007 locks up when I try to build a new query off of a crosstab query? I can't even get it placed on the query design grid, it just sits there and I have to shut down to get out of Access. If it finally does drop it in (1 time out of 10), I lose it when i try to save...

Part and Inventory Search

Back
Top