top 10

[Paul200968]

Hi,

I was wondering if it possible to add a column in a query which shows the recordnumber of that query incrementing with 1.


The reason for this is that I want to create a top 10 (records)
I was thinking of a function but Im not familiair with that.

rgrds,

Paul from Holland.

 

[Oldsoftboss]

If you create a query, when in design view, click on the properties icon. From there you can select the no of records to return.

Dave

 

[Paul200968]

If you create a query, when in design view, click on the properties icon. From there you can select the no of records to return.

Dave

Dave,

I've selected the query and properties and entered for example 10. When I re-run the Query, it still shows all the records?

Can you help please.
Paul

 

[Paul200968]

If you create a query, when in design view, click on the properties icon. From there you can select the no of records to return.

Dave

Dave,

I used the wrong field, just spotted the attachment. sorry for this. But when I use top 10 it does not shows 10 records because I have records with same values. Thatswhy I was hopping that I could count the records.


Can you help please.
Paul