• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

SQL to Show Count(*) of Prices in Form

See simple Form1 attached.

I have a very simple table structure.
Multiple suppliers supplying multiple products.

Therefore in the tblPrice a single product could have multiple prices.

I want the YELLOW box in form1 to show the count(*) of prices in the tblPrice for me.productid.

(Therefore in the sample form the YELLOW Box for for ProductID =1 should show a value of two.  Since there are two suppliers providing prices for this product).
Database2--2-.zip
0
Patrick O'Dea
Asked:
Patrick O'Dea
1 Solution
 
Rey Obrero (Capricorn1)Commented:
see this, change the record source of the form to query1
Database2.mdb
0
 
Patrick O'DeaAuthor Commented:
Thanks!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now