Set 2 fiels to same value

mickyp

Hi There,

I have an access database where I would like to set two fields to the same value.
Both fields are in the same table called Sampletbl

The one field is called Year and the other Years.

Is there anyway to get access to populate field year with the same value as field years automatically.

Thankx
MickyP

PEB

Hi,

The way to do it is to use an Update Query!

You have to do a new query and in SQL view you type the folling SQL:

UPDATE [Sampletbl] SET [Sampletbl].Year = [Years];

And than you press the run sql buton and you run the query!

Will appear a message that your records will be updated!

msquared

You don't say where you would like this update to happen. For example, is it during a user entering data on a form, etc.

Quote:

Originally Posted by mickyp

Hi There,

I have an access database where I would like to set two fields to the same value.
Both fields are in the same table called Sampletbl

The one field is called Year and the other Years.

Is there anyway to get access to populate field year with the same value as field years automatically.

Thankx
MickyP

Set 2 fiels to same value

re: Set 2 fiels to same value

re: Set 2 fiels to same value

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about