Option count into a query

  • Thread starter Thread starter Oli
  • Start date Start date
O

Oli

I have a query on three table. I need to count the number
of line (regarding the query result) by ID number
 
Dear Oli:

Simply producing the count of the number of lines produced by a query
would be quite independent of any column of the results. Perhaps you
want a ranking column that counts down the rows starting from 1. If
so, you might start from a query like this:

SELECT ID,
(SELECT COUNT(*) + 1 FROM YourTable T1
WHERE T1.ID < T.ID) AS Rank
FROM YourTable T
ORDER BY ID

Add other columns as desired

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Query Report- Really Need HELP! 2
Access Dcount (multiple criteria) 3
Totals Query with Multiple Counts 3
Need to Count by two different criteria in same Totals query 4
Can a Table be Updated From a Subquery with Aggregate Count Value? 6
Count unique in a query instead of count # 5
Dcount returning no results!!! 0
Total appointments per agent 2

Back
Top