Can fields in Access Tables be referenced by Number?

[Robeen]

Do fields in Access Tables have a 'Number' property that you can use to reference them?

For example, if you have the following fields:
EmpID
FName
LName
Department


Hire_Date
. . . is there a way to query an employee's Hire_Date by telling Access to return the value that is in the 5th field [Hire_Date]?

I have never had to do this but I am trying to help with another post where being able to refer to fields by their position in the field list would be helpful.
https://www.accessforums.net/queries...lds-25339.html

[pbaldy]

In what situation? You certainly can in a recordset:

Rs(0)

Would refer to the first field.

[Robeen]

Hi Paul,
Thanks for replying!

The post that I was looking at:
https://www.accessforums.net/queries...lds-25339.html
was indicating a need to be able to get a number [say 5] [the example shows single-digit numbers]
from a field in Table1 . . .

and use that number [5] to sum the values:
In the [5] fields
After the 8th field in Table2.

[pbaldy]

Like I said, I know it can be done in a recordset. In a query, I know you can use ordinal position in the ORDER BY clause, but I don't think it works in the SELECT clause. Not clear on what the goal is in that other thread, but my guess is it would have to be done in code anyway.

[Robeen]

Thanks, Paul! Appreciate it.
I hope things are good with you!

[pbaldy]

Life is good my friend; hopefully for you too!

[Robeen]

Life is good my friend; hopefully for you too!

My son just finished his first year in college . . . we seldom see him. I'm having separation anxiety - hoping he stays safe.

[pbaldy]

I feel your pain. I've got a daughter in England and the other in Nepal. It's like they're trying to get as far away as possible.

[Robeen]

lol . . .
I shouldn't laugh . . . but Nepal is pretty darned far. It sure looks like she's making a statement!
I went to school in Darjeeling, India and visited Nepal several times. It was foreign enough for me . . . but they are used to travellers there.