update queries, help needed please !

[locutus]

Hi Guys
Thanks for taking the time to read.
I am trying to make a update querie in access.
Here's what I need to do, I have a table in access, the 3 fields I am working with are called:

Invgrp : productgrp : and Unit

Invgrp will have either 80 or 82 as the data ( as text )
productgrp will have a two digit number as text such as 55 or 66 or 42 etc.
and unit will have KG ( Unit of measure )

first of all I need to combine the Invgrp and productgrp fields so I can read a four digit string. ie "8052"
I have found out how to do this in an access querie.
newfield: [Invgrp]&[productgrp]

now I need to say if the combination of these fields ie newfield = 8055 or 8060 then change the value of unit field to "EA" instead of "KG"

Is this clear ?

hope you guys can help, remember this needs to be an update querie instaed of VBA code.

Cheers , Locutus

[JeroenDEGA]

Go to View, SQL and try the next:

UPDATE tblTable SET tblTable.Unit = "WHATEVERUWANT"
WHERE ((([Invgrp] & [productgrp])="8055" Or ([Invgrp] & [productgrp])="8060"));

Good luck

[locutus]

that did the job nicely , cheers mate