simple query

[Guest]

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.

 

[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