Search results for query: *

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...

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

Thanks for all of your help Trevil! You ROCK!

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

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

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!

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

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

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 =(

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

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.

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...

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...