Adding 2 values in 2 queries

[Guest]

I have 2 queries 4monthEligibleIDs and another query 4monthTerminated.
Here is what is in each
4monthEligibleIDs:
SELECT count(*) AS count4MonthEligible
FROM Query4MonthEligibleIds;

4monthTerminated:
SELECT count(*) AS count4MonthEligible
FROM 4MonthTerminated;

What I need to do is change the 4monthEligibleIDs query so it still counts
the 4monthEligibleIDs and then adds what is in the 4monthTerminated field.

And the result of the 2 additions should be in the field count4MonthEligible
in the 4monthEligibleIDs query.

Does this make sense?
The reason that I have to have the result in that specific field is in the
reports this is what is being used to get the data from and would be alot
easier if I could do it this way.
Thanks

 

[JohnFol]

Have you looked at setting the controlsoruce of the text box on the report
to be

= DCount("*", "Query4MonthEligibleIds") + DCount("*", "4MonthTerminated")

 

[Guest]

No, I have not thought of that, I will try that but I would still like to
know the way i described if possible.