Adding text in update question/query

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

Hi

Does anyone know if it is possible to add text if I create
an update question/query in Access.
I don't write any code I just linked some tables in access
DB window and created an query.
I want to add text to a field not replace any text that is
in that field already.
 
Christina said:
Hi

Does anyone know if it is possible to add text if I create
an update question/query in Access.
I don't write any code I just linked some tables in access
DB window and created an query.
I want to add text to a field not replace any text that is
in that field already.
Click to expand...

Sure, try something like this:

Update Table1 Set MyField = "Some text"
Where MyField Is Null
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
The following expression, entered into the Update row in query design view,
will append the text ' Updated: ', followed by the current date and time, to
the 'Notes' field in the 'Employees' table in the 'Northwind' sample MDB ...

[Notes] & " Updated: " & Now()
 
Back
Top