-
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
-
Go to View, SQL and try the next:
UPDATE tblTable SET tblTable.Unit = "WHATEVERUWANT"
WHERE ((([Invgrp] & [productgrp])="8055" Or ([Invgrp] & [productgrp])="8060"));
Good luck
-
thanx
that did the job nicely , cheers mate
