Count bills if customer id is same (1 Viewer)

aligulsoomro

New member
Local time
Today, 09:14
Joined
Apr 12, 2018
Messages
1
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

Duly Registered Boozer
Local time
Yesterday, 23:14
Joined
Apr 30, 2011
Messages
1,808
You could use a subquery, or alternatively (but possibly less efficient) you could use DCount.
 

Users who are viewing this thread

Top Bottom