Add a numbering sequence for instructions using a query.

[Mineral Spirit]

I have a table with different machines. A second table with different common instructions for those machines. My query is able to sort the instructions for each individual machine but I need to add a number to order the sequence for a complete procedure (re: Instruction 1, 2, 3...). Thank you for any help.

[ranman256]

Add another integer field,
number the instructions 1 thru N.

[Mineral Spirit]

Can it be done automatically?

[orange]

It sounds like you have X machines. And that you may have a number of processes (Y) that involve machines.
It also seems, and I could be way off base here, that the instructions are for using a particular machine or machines in doing some process or processes.

Could you clarify your use of machine(s) and instructions? An example of what you have and what you need would be helpful.

If it is how to start and operate and shut down each machine, then you could add a field to your machineInstruction table to identify seqNo.
However, until we know the facts it is difficult to offer more focused advice.
Good luck.

[Mineral Spirit]

The purpose is to set lock-out-tag out procedures for each machines. Each individual processes need to be in right sequence. Upon scope of repair, only selected processes are needed to lock machines. So numbering is used for sequencing and selecting lock-out processes.
See sample below of desired output. I want to sequence the blue column.
(Instructions are in French)

Machine: Mixer 8 15 hp

# Proc	Risques	Contrôle	Localisation
1	Notification	Aviser les employés concernés
2	Électriques	Éteindre l'équipement
3	Électriques	Fermer et cadenasser le contacteur	Salle MCC-1
4	Électriques	Faire un essai de mise en marche de l'équipement
5	Pneumatique	Fermer et cadenasser l'arrivée d'air comprimé
6	Pneumatique	Évacuer l'excès de pression d'air
7	Force de gravité	Abaisser l'équipement à son point le plus bas
8	Force de gravité	Si requis, installer un support pour prévenir la descente des équipements

[isladogs]

If the sequence number is always the same for a specific action on different machines, then ranman's suggestions will work.
If however, a specific action may be step 1 for one machine or process but step 2 on another, that method won't work.
Instead you could create rank order queries to get the sequence numbers

[Mineral Spirit]

Thank you for your input.
Finally I used Excel to generate my sequence number and then transfer data into the Access Dbase.

[orange]

For completeness can you show us a sample of your solution for 2 or 3 different machines?

I want to sequence the blue column

.
There was no blue column.

Your solution may help others.