Using the name of a field in a query

[Mack2]

I have a field in a table called 2007 lls. I want to store the first 4 digits of the field (the 2007) as a value in a record. For example:
I am guessing in a query something like this;
field name: Year:2007lls
Records: 2007
2007
So I need to grab the 2007 and store is a a value. Any Ideas? THANKS

 

[kjv1611]

What about using the TableDefs object properties to delve into the properties of the table you want to look at?

 

[Mack2]

I have never used tabledefs properties. How would I access them?

 

[Golom]

I have a field in a table called 2007 lls. I want to store the first 4 digits of the field (the 2007) as a value in a record.

Not at all clear about this.

The table name is "2007 lls"?
The field name is "2007 lls"?
The value stored in the field is "2007 lls"?

You want to
- Store it in the same table and record but a different field?
- Store it in some other table and field?
- Display it as a field in a query?

 

[TheAceMan1]

How are ya Mack2 . . .

A function to return the 1st four as numeric:

[blue]Public Function Get4(fldName As String) As Long
   Get4 = CLng(Left(fldName, 4))[/blue]

See Ya! . . . . . .