Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updating a field by using formula and where statement
UPDATE (Deneme AS D INNER JOIN FlowSumSKUCountryTON AS F ON (D.[Product Code] = F.[Product Code]) AND (D.Unica = F.Unica)) INNER JOIN FlowSumUnicaCountryTON ON (F.Unica = FlowSumUnicaCountryTON.Unica) AND (F.Countries = FlowSumUnicaCountryTON.Countries) SET D.[Percent] =...- johnbeck
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Updating a field by using formula and where statement
Hi all, I am trying to update a field in a table with the sql below. I want to update one field only with the given criteria below. But it gives me the bloody pop-up message "Enter Parameter Value for [FlowSumSKUCountryTON]![Product Code] and others...". Any clues? I tried to put = instead of...- johnbeck
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
