CREATING AND RESETTING COUNTER ON A FORM

[NewComer]

What I was actually trying to do is find a way to return only the top 6 part numbers grouped by task number. It was suggested that I create a form with a counter that resets everytime the task number changes, running the entire table through this form. This would allow me to untilize this counter field to retrieve the top 6 part numbers per task number.

Would appreciate any help with how to create counter and reset it with every task number change.

Thanks !

 

[JoaoTL]

Buil a Select Query and make it the Form Record Source
Use the Select Top .. Sintax.


SELECT TOP 6
...
...
...
Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[NewComer]

Thanks for the help but will this return the top six for each task number or over all. Need it by each task number.
Thanks