Is there a VBA command that will allow me to reference a records specific field in a table.
I have a very small table and I wanted to use it as a header in my report which I download to excel. I just want to reference a field in a table which is very small and put this on my inserted Top line as part of my header.
Example
Table 1
Record 1 = 35,307,1
Record 2 = 35,308,1
I just wanted to write a quick loop which will pull out 307,308.
The loop is no proble I was just wondering if there was a command to reference the value of a specific field of a record.
I have a very small table and I wanted to use it as a header in my report which I download to excel. I just want to reference a field in a table which is very small and put this on my inserted Top line as part of my header.
Example
Table 1
Record 1 = 35,307,1
Record 2 = 35,308,1
I just wanted to write a quick loop which will pull out 307,308.
The loop is no proble I was just wondering if there was a command to reference the value of a specific field of a record.