To count the number of lookup options

[lizzywu]

Hi there,

I tried to use a query to count the number of different lookup options (call_outcome) for the customers in my database. There are seven lookup options. If I only want to get the number of call outcomes which must be among the lookup option 1, 2, 3, is it possible to get exactly one number for each customer?



I attach my database here. The query I did gives me more than one number for each cumtomer. But I do need only one number that tells me the total number of calls made.

Thank you very much.

[orange]

Please show the query sql.

[lizzywu]

Orange, I attached the mdb version. Thank you.

[orange]

Try this

SELECT t_customer.customer_id
, Count(t_lookup_outcome.outcome_id) AS cnt
FROM
t_lookup_outcome INNER JOIN t_customer ON
t_lookup_outcome.outcome_id = t_customer.call_outcome
WHERE (((t_lookup_outcome.outcome_id) In (1,2,3)))
GROUP BY t_customer.customer_id;

[lizzywu]

Yes, exactly what I want. Thank you very much, Orange.