How do I make a call to another query in my current report?

[darkhat01]

How do I make a call to another query to do a Sum of all the Q1's that equals 1? Currently the Record source for the report is one query qManagers and this gives me 90% of the data that I need and I also need results from another query called qEnterpriseQuery.

Here is what I was thinking, but it is not working?

=Sum(Abs(qEnterpriseQuery!Q1=1))

Thanks,
Darkhat01

 

[Remou]

You need a Domain Aggregate Function, this may suit:

[tt]=DSum(Abs("Q1","qEnterpriseQuery")[/tt]

 

[darkhat01]

That helped alot by doing a DCount for everything, but what would I do if I only wanted to count it if Q1 equals 1?

Works if I want to count everything.
=DCount("Manager","qEnterpriseQuery")


I tried =DSum(Abs("Q1","qEnterpriseQuery")) and I Get a error that tells me "The expression you entered has a function containing the wrong number of arguments."

Thanks,

Darkhat

 

[Remou]

You can use a Where argument:

[tt]=DCount("Manager","qEnterpriseQuery","Q1=1")[/tt]

 

[darkhat01]

I also tried somethign like this and it did not work:
=DSum(Abs("Q1","qEnterpriseQuery","Q1"=1))

 

[Remou]

It wouldn't. Here is an example:

=DSum("Abs(Q1)","qEnterpriseQuery","Abs(Q1=1)"))

Are you saying that you want to sum where Q1=1 or Q1=-1?