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

  1. anhfuego1

    How do I get UNIQUE Data?

    I created a query to capture how many UNIQUE customers there would be in a given time frame. A single customer may have multiple orders. I created a parameter query to capture the time frame. How would I get the total count of UNIQUE customers? Table: Orders Field: Cust_ID and Ord_Date Is...
  2. anhfuego1

    Anyone Help With SUM IIF Statement.

    Yeah, I got it. thanks again for all of your advice.
  3. anhfuego1

    Anyone Help With SUM IIF Statement.

    Thanks for all of your help Trevil! You ROCK!
  4. anhfuego1

    Anyone Help With SUM IIF Statement.

    SELECT "" AS [Desc], dbo_vwProjectedDemand.CustomerProspect, dbo_vwProjectedDemand.CustomerClass, dbo_vwProjectedDemand.ProspectClass, dbo_vwProjectedDemand.Category, dbo_vwProjectedDemand.CategoryDesc, dbo_vwProjectedDemand.GroupValue, dbo_vwProjectedDemand.ActualMailDate...
  5. anhfuego1

    Anyone Help With SUM IIF Statement.

    I did what you suggested, but a prompt pops up stating that I cannot define a field more than once. What to do now?
  6. anhfuego1

    Anyone Help With SUM IIF Statement.

    Truthfully, I thought that I could just sum up the fields in the report and not have any criteria in the query. But that proved invalid. I am not well versed in SQL to understand what you meant w/ your last post. Please clarify. thanks!
  7. anhfuego1

    IF NULL - THEN N/A

    Place the IIF in the report criteria. Let me know if it works =) Fuego
  8. anhfuego1

    Anyone Help With SUM IIF Statement.

    SELECT "" AS [Desc], dbo_vwProjectedDemand.CustomerProspect, dbo_vwProjectedDemand.CustomerClass, dbo_vwProjectedDemand.ProspectClass, dbo_vwProjectedDemand.Category, dbo_vwProjectedDemand.CategoryDesc, dbo_vwProjectedDemand.GroupValue, dbo_vwProjectedDemand.ActualMailDate...
  9. anhfuego1

    Anyone Help With SUM IIF Statement.

    Yes I do have a query for the record source. the data streams in through a view table on the network here. I tried to place my IIF there but the results came back null. I still can't find the correction =(
  10. anhfuego1

    IF NULL - THEN N/A

    Yeah sure, try: =IIF([fld1] Is Null,N/A,[fld1])
  11. anhfuego1

    Anyone Help With SUM IIF Statement.

    Trevil, in response, I tried to that Formula and it doesn't work. Access still recognizes it as a parameter query. Any other suggestions would be awesome, thanks.
  12. anhfuego1

    Anyone Help With SUM IIF Statement.

    I created an IIF statement formula that pulls data if it meets the criteria. If data is null in the Plan Circ(Text285) then it pulls data from Circulation(Circulation) into a 'make-shift' cell named CircForPlanCalcs: The IIF works fine, it's just that I need to SUM up the pulled data. Everytime...
  13. anhfuego1

    How do I SUM an IIf Statement?

    I created an IIF statement for cell named CircForPlanCalcs: =IIf([Text285] Is Null,[Circulation],[Text285]) is the formula. it works fine, I only need to find a way to SUM up these values that it pulled. I tried Sum([CircForPlanCalcs]) but it recognized it as a parmater query. Any help...

Part and Inventory Search

Back
Top