Display how many product

[syah96]

I want to know how to make a textbox that will show how many product being buy by customer. For example he buy 10 product (i will input product id and evrything). The in the reprt it will show how many item being buy by each of the customer

 

[Golfer]

Assuming you have a customer 'id' field and a sales table you can create a query that simply groups the customer id and then a count of products.

 

[syah96]

Assuming you have a customer 'id' field and a sales table you can create a query that simply groups the customer id and then a count of products.

I get it. Thank You. But is there any way to put it on control source textbox. Or any good form example may help. (I cant find it)

 

[Golfer]

personally i would create a small pop up form that you can call by double clicking the customer id and using that action as the query criteria - example [Forms]![F_Sales]![Cust_id] then create a macro calling the sub form.