Count bills if customer id is same (1 Viewer)

[aligulsoomro]

I have two tables, one customers other is bills.
I have created a query from customers table, in which i want to show the column number of bills by this customer.
So I need support to count number of bills from bills table where customer ID is same.

 

[Beetle]

You could use a subquery, or alternatively (but possibly less efficient) you could use DCount.