Values

[Guest]

Why can't access show totals that have 0 as it's value.

I'm tracking commissions on a yearly basis and some clients have no
commisison to date. I need those clients to show, even though they don't
have commission generated thus far. Please let me know if this can be done.

Thanks,

Andre Adams

 

[Guest]

Show where?

 

[Guest]

It may be the field you are totaling has nulls in it. Access will show a
total of 0; however, depending on your filtering, it may be excludinging
those with Nulls.
Post some detail on what you are doing and perhaps we can find you a solution.

You question is sort of like "I dropped my line in the water. Why didn't I
catch any fish?"

 

[John Spencer]

In a query, you would need a table of clients that was outer joined to the
commissions table.

The SQL for that might possibly look like:

SELECT Clients.ClientID, Sum(Commission)
FROM Clients LEFT JOIN Commissions
ON Clients.ClientID = Commissions.ClientID



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..