concateneren in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you several text fields concateneren in access in 1 query to 1 text
field? Bijv. Text1 = 1111, Text2 = 2222, Text3 = 3333. the result must be:
"111122223333".
 
Type this into the field row of a column in your query (ConCat is just any
name for the new field)

ConCat: [Text1] & [Text2] & [Text3]
 
Back
Top