Count Ifs

[samthomasny]

I have a query where I have to summarize the Sales$ and # of orders within a set date range.

For Sales$ my query works just fine - Sales$: Sum(IIf([tbl_Orders ]![HENTDT]>=[tbl_Campaign]![Begin Date] And ([tbl_Orders ]![HENTDT]<=[tbl_Campaign]![End Date]),[tbl_Orders ]![TOTAL],0))



I'm trying to replicate the same logic for counting # of Orders by using Count function, but it is not working. Can someone please tell me what it wrong with this query - Order Count: Count(IIf([tbl_Orders ]![HENTDT]>=[tbl_Campaign]![Begin Date] And ([tbl_Orders ]![HENTDT]<=[tbl_Campaign]![End Date]),[tbl_Orders ]![ORDER#],0))

[pbaldy]

I would still use Sum, but use 1 in the True argument instead of a field.

[samthomasny]

I really appreciate the help. That simple solution really worked !!

[pbaldy]

Happy to help!