Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?"
 
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
..
 
Back
Top