Update SQL Query; Concatenate 3 existing fields.

[tburns]

I have a field MAPLOT which is empty. I would like to concatenate three fields: MAP1 LOT and SUB which have values into the field MAPLOT. Here is my pitiful stab at this so far:

UPDATE: [maplot] = [map1] + [lot] + <sub>;

Thanks in advance, first time supplicant.</sub>

 

[DougP]

I would do it like this

Create your Update statement with a static value
and get it to work
then
right above that line put your concatenetaion routine

MyVariable = [MAP1] &amp; [LOT] &amp;
UPDATE [yourTable] SET [yourTable].[maplot] = &quot; &amp; MyVariable &amp; &quot;;&quot;

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
Or visit my WEB site

http://www.barcodeone.com