Simple question,

[macace]

Ok, here it is, I have a table (big one) with two fields ID and NAME, now I
added one more field called TYPE that has the same value for all the records.
Example;

ID Name Type
1 car blue
2 bike blue
3 train blue

Since the TYPE field wasnt there from the begining, now I have to input the
TYPE manually for all the records. Is there a way to copy, for example, the
word blue on every record at once. I tried copy and paste but it does not
work for me also I tried to Find & Replace, but I dont know how to make it
look for an empty field and replace it with "blue". Any ideas?.

Thanks

 

[SendObject - Macros]

Hey,
try doing a update query and update the field TYPE with "BLUE" on the
'Update to:"

see if this helps......

 

[fredg]

Ok, here it is, I have a table (big one) with two fields ID and NAME, now I
added one more field called TYPE that has the same value for all the records.
Example;

ID Name Type
1 car blue
2 bike blue
3 train blue

Since the TYPE field wasnt there from the begining, now I have to input the
TYPE manually for all the records. Is there a way to copy, for example, the
word blue on every record at once. I tried copy and paste but it does not
work for me also I tried to Find & Replace, but I dont know how to make it
look for an empty field and replace it with "blue". Any ideas?.

Thanks

The Update query will be what you are looking for (answered by someone
else).
But....
Name and Type are reserved Access/VBA/Jet words and should not be used
as field names.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

 

[macace via AccessMonster.com]

Thank you so much!. I will try that.

Ok, here it is, I have a table (big one) with two fields ID and NAME, now I
added one more field called TYPE that has the same value for all the records.

[quoted text clipped - 12 lines]

Thanks

The Update query will be what you are looking for (answered by someone
else).
But....
Name and Type are reserved Access/VBA/Jet words and should not be used
as field names.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'