none
Query Filtering Results? RRS feed

  • Question

  • Hello, I need help again!

    I have a very simple query that is pulling in "Company Info" "Open Opps" "Won Opps" "Total Won" "total Open".  the open opps and the won opps are check marks.  The total won and total open are total sums.

    I want to tell the query to find the results of open opps and totals of the won opps based on which check mark is checked.

    I am running a report off the query that I review with my boss and want to have totals for each.

    My table running the query is totaling the totals for all jobs combined.

    What expression do I write in the design view Total won / Total Open fields to tell them to ONLY calculate corresponding CHECK boxes for each?

    Thanks,

    Steven

    Thursday, February 2, 2017 1:05 AM

All replies

  • Hi Steven,

    I am afraid it is difficult to understand your requirement. I would suggest you share us your Table Design and Table records, your current query and the expected result you want by query.

    Best Regards,

    Edward


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, February 3, 2017 6:29 AM
  • Hi Steven,

    You could try using an Iff() statement. For example:

    TotalWon: Sum(IIf([Won Opps],1,0))

    Hope it helps...

    Friday, February 3, 2017 4:11 PM