How do I programatically get a field value from a table?

[VBAguy22]

Hello
I have an Access table. I have a field called "LastUpdateDate" which is the same for the entire table and contains the last date of the last update of the information in the table.
How do I programatically retrieve last update date?

 

[BNPMike]

Are you saying you have a field in your table that has the same value for every record?

Wierd.

 

[VBAguy22]

no no
it has the same value for every record only in one field. sorry for misunderstanding
I'd be happy if i got the first value of that field

 

[Golom]

Your fingers say "no no" but your explanation says "yes yes".

Not that's its really important for your question, but why would you have a field whose value on every record is the same?

Do you update that field in every record to a constant value every time something is updated?

As to your question
[tt]
myLastUpdateDate = DFirst ( "LastUpdateDate", "TableName" )
[/tt]

 

[VBAguy22]

yes I do. thanks for the codE

 

[Edski]

OK, I give up. Why do you have a field with the same value for every record in your table? Surely you could just store it in one record of another table. The suspense is killing me.

 

[BNPMike]

VBAguy, it's Friday so I predict you're going to romp home as "Denormaliser of The Week".