Not sure what I am doing wrong. I want to make a field within a TABLE to concatenate a DESCRIPTION field, COLOUR field and COLOURID field to a SAGEDESCRIPTION field to import into sage.

eg  Headrail, White, 8390  to  become  Headrail White 8390 in the Sagedescription field. How do I do it.

I have looked at youtube but feel I watched and took it in wrong but cant find GOAC104 from the youtube video.  However, I created a form, typed =[DESC]&" "&[COLOUR]&" "&[COLOURID] works just in the form,but in the table the SAGEDESCRIPTION is blank. How do I get data into the SAGEDESCRIPTION field within my TABLE.