2 querys in 1 report?

  • Thread starter Thread starter Ady
  • Start date Start date
A

Ady

Hi There

I am creating a report. In this report I need to total the number of e-mail
marketing allowed=true, and the total for e-mail marketing allowed=false.

At the moment I am creating a simple query for e-mail marketing allowed=true
and doing a report from this. Then creating another query for e-mail
marketing allowed=false. Then doing a report from this.

What I would really like to do is show the number of:
e-mail marketing allowed=false
e-mail marketing allowed=true
on one report. Can I pull the info in from both queries onto one report. If
not can I create a query which will do the same and then create a report
from this?

Any help will be highly appreciated.

Many thanks in advance.

Ady
 
What I would really like to do is show the number of:
e-mail marketing allowed=false
e-mail marketing allowed=true
Click to expand...

You can do this in a Query: put in two calculated fields

AllowedTrue: IIF([E-mail marketing allowed], 1, 0)

and

AllowedFalse: IIF([E-mail marketing allowed], 0, 1)

Use the Sum (not the Count!) operator on these fields.
 
Hi

This solved the problem!

Thank you very much indeed!

Ady



John Vinson said:
What I would really like to do is show the number of:
e-mail marketing allowed=false
e-mail marketing allowed=true
Click to expand...

You can do this in a Query: put in two calculated fields

AllowedTrue: IIF([E-mail marketing allowed], 1, 0)

and

AllowedFalse: IIF([E-mail marketing allowed], 0, 1)

Use the Sum (not the Count!) operator on these fields.
Click to expand...
 
Back
Top