Simple question,

  • Thread starter Thread starter macace
  • Start date Start date
M

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
 
Hey,
try doing a update query and update the field TYPE with "BLUE" on the
'Update to:"

see if this helps......
 
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
Click to expand...

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'
 
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.
Click to expand...
[quoted text clipped - 12 lines]
Thanks
Click to expand...

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'
Click to expand...
 
Back
Top