Help with query in Microsoft Access

Question

I have 2 tables:

Table B has full barcode and name, Table A has only code.

I need to run update query that fill name in Table A.

I tried something like:

update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8))

but it doesn't work.

At first glance, it seems it should work. what is the error? — shahkalpesh
– shahkalpesh, Commented Mar 8, 2010 at 9:23

Fionnuala · Accepted Answer · 2010-03-08 12:09:14Z

2

Name is a reserved word, you need to put it in square brackets: [name]

In general, fields (columns) should not be named with reserved words.

answered Mar 8, 2010 at 12:09

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1