Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Query in Access 2007 for Running Count

Avatar of wlreimer
wlreimer asked on
Microsoft Access
17 Comments1 Solution697 ViewsLast Modified:
I have a table with the following columns: Vendor, Product.
I need to create a query that will count for each Vendor/Product combination so that I get the following:
Vendor | Product | Count
ACME        ABC       1
ACME        ABC       2
ACME         DEF       1
BOLTS       GHI        1

This the reason behind this, I need to be able to use the count field in another query so I need that count to be dynamic based on the info currently in that table.

I can do this in a report, but have tried and tried, searched and searched and can't find a solution to work in a query.

Any help would be appreciated.