Dirk Goldgar

  • Thread starter Thread starter DevilDog1978
  • Start date Start date
D

DevilDog1978

Thank you for your help. I have one last question. Using the SQL statement
below, is there a way I can tell Access to add one more requirement before
changing std_cal to "Y"? I would like for it to also look at
standards_t3.item_nbr. standards_t3 is the table and item_nbr the field.
Basically, if the sub_cust meets the requirements already placed on it and
the item_nbr in pcinventrySQL matches the item_nbr in standards_t3 then it
can change std_cal to "Y".
 
DevilDog1978 said:
Thank you for your help. I have one last question. Using the SQL statement
below, is there a way I can tell Access to add one more requirement before
changing std_cal to "Y"? I would like for it to also look at
standards_t3.item_nbr. standards_t3 is the table and item_nbr the field.
Basically, if the sub_cust meets the requirements already placed on it and
the item_nbr in pcinventrySQL matches the item_nbr in standards_t3 then it
can change std_cal to "Y".
Click to expand...

Exact match, or wild-card match?
 
DevilDog1978 said:
Thanks to your help everything is now a direct match.
Click to expand...

This ought to do it:

UPDATE
(pcinventrySQL INNER JOIN standards_t3
ON pcinventrySQL.item_nbr = standards_t3.item_nbr)
INNER JOIN tblLabCodesToUpdate
ON pcinventrySQL.sub_cust Like tblLabCodesToUpdate.LabCode
SET pcinventrySQL.std_cal = "Y"
 
DevilDog1978 said:
You are awesome. Thanks for all your help. Recommend any good books for
newby's?
Click to expand...


_Microsoft Office Access 2003 Inside Out_, by John Viescas, from Microsoft
Press

_Designing Effective Database Systems_, by Rebecca Riordan, from
Addison-Wesley (I think)

For the slightly less "newbie", with a developer orientation, the best I've
read is _Access <version> Developer's Handbook_, by Getz et. al., from
Sybex. There's no new edition after the Access 2002 version, unfortunately,
but it's still a terrific book for the developer.
 
Back
Top