Couting Line Items per Order Number in a query

[weightinwildcat]

I am working on a query, for which I need a calculated field to show the number of line items. The sequence should work like this:

Order Number Line Item Count
100 1
100 2
100 3
100 4
100 5

105 1
105 2
105 3

I have experimented with DCount and DSum, without success. Any suggestions would be appreciated.

 

[Andrzejek]

I would guess you need to Google something like: "access ranking query group by"

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[dhookom]

Does the query need to be updateable? Also, it is necessary to have another field in the table that identifies the "sequence". Do you have such a field like a primary key?

Duane
Hook'D on Access
MS Access MVP