Fill Field in same value

  • Thread starter Thread starter Guest
  • Start date Start date
If I understand correctly, to place the letter "A" in a field in all records
in a table, create an update query with sql like:

UPDATE tblNoNameGiven
SET [FieldNoNameGive]="A";
 
Thanks for replay
I have blank filed with name CRSn and I want replace A letter with blank.
Please help me

Duane Hookom said:
If I understand correctly, to place the letter "A" in a field in all records
in a table, create an update query with sql like:

UPDATE tblNoNameGiven
SET [FieldNoNameGive]="A";


--
Duane Hookom
MS Access MVP

Hamoud Alrashid said:
Hi, there
I want to put "A" ltr in a filed in all records.
Please help
Have a great time
 
This is a bit like hitting a moving target. How about your tell us your
table name, your field name, and the value you want to put into the field.
Also let us know if all records get the new value or if there is some kind
of criteria.

--
Duane Hookom
MS Access MVP

Hamoud Alrashid said:
Thanks for replay
I have blank filed with name CRSn and I want replace A letter with blank.
Please help me

Duane Hookom said:
If I understand correctly, to place the letter "A" in a field in all
records
in a table, create an update query with sql like:

UPDATE tblNoNameGiven
SET [FieldNoNameGive]="A";


--
Duane Hookom
MS Access MVP

Hamoud Alrashid said:
Hi, there
I want to put "A" ltr in a filed in all records.
Please help
Have a great time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Problems 1
copy value 3
excel question 3
format split 2
Unique values in two fields in query 1
acnewrec? 1
Copying field value to multiple records in same table 1
Inserting a character in a message 1

Back
Top