simple query

T

Trace

It's been a while since I used access and need a refresher.

I have 2 tables. One lists all the customers who called in on sept 8. The
second lists the customers who called in on sept 8 because of one specific
product. How do I set up a query to show the percentage of customers who
called in about the specific product on Sept 8th as compared to those who
called with other issues on sept 8th.
 
M

Michel Walsh

Hi,


if a and b are the two "count" of records, from each list, and if the lists
are disjoint, then a / (a+b) is the ratio you look for.


Hoping it may help,
Vanderghast, Access MVP
 
Top