Please Help

[cassmrc]

I have a Table with 4 columns of information
Column 1 - ID No.
Column 2 - Name
Column 3 - Max ID
Column 4 - Min ID

Column 1 has and ID number which identifies the piece in the Name column.
Column 3 and Column 4 contain numbers which are in Column 1

 
ID Name Max Min
1   Apple 1     2
2   Orange 2   2

What I need to do is to replace the values in the Max and Min fields with the Value from the Name field.

Hope this makes sense.

[RuralGuy]

No that does not make too much sense. You want to copy a string value over two numeric values in a table?

[cassmrc]

Yes that is what I need to do. The attached PDF may clarify things.


Thanks in advance.

[RuralGuy]

That does not help too much. Is this in MS Excel or MS Access?

[cassmrc]

Sorry the data is in MS Access.

[RuralGuy]

Is this an exersize for some class or is there a real world reason to do this? Are all of the fields text? Are you supposed to do it with a query?