2 querys in 1 report?

[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

 

[John Vinson]

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

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.

 

[Ady]

Hi

This solved the problem!

Thank you very much indeed!

Ady

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

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.