Totals Query To Sum With No Detail

[David Portwood]

Given a list of Account IDs, I'd like to sum the number of contracts
associated with each Account. I only want active Accounts to count toward
the sum.

The problem is that when I add criteria to restrict to active Accounts, the
inactive Accounts are ignored entirely by the query. They aren't listed at
all in the resulting set of records. I do want to see the Inactive Accounts
listed but they should equal zero.

Can anyone help me with this?

 

[Larry Linson]

Given a list of Account IDs, I'd like to sum the number of contracts
associated with each Account. I only want active Accounts to count toward
the sum.

The problem is that when I add criteria to restrict to active Accounts,
the inactive Accounts are ignored entirely by the query. They aren't
listed at all in the resulting set of records. I do want to see the
Inactive Accounts listed but they should equal zero.

Can anyone help me with this?

If the inactive accounts are "ignored entirely by the query," it is because
you made it so.

How you would accomplish what you want will depend on the tables, fields,
and data that you have, which you have not told us in detail. If you will
clarify, and be specific, then perhaps someone will be able to offer you
some concrete suggestions.

Larry Linson
Microsoft Access MVP

 

[David Portwood]

Found it. Join Properties.