I am trying to add a web hyperlink field to an existing table.

The table name is [eQPRUpdate] and the targeted fieldname is [hyperlink]

Currently I have the extention for all the links in a field called "QPR Number". I also have a common address that proceeds the extention for all the records.
https://www.portal.toyotasupplier.com/ncdext/webpartpages/qpr.aspx?sn=T00TNA01,52111,466&NCDNum=

I need to create a query that will allow me to joing the prefix link above to the extention that is located in the field named "QPR Number"

I would like these to go into a field called "hyperlink"

Is simple to do?

Thank you.

UPDATE EQPRUpdate SET EQPRUpdate.hyperlink = "https://www.prime...." & [qpr number];


JR