access17401
Registered User.
- Local time
- Yesterday, 18:03
- Joined
- Aug 24, 2017
- Messages
- 33
I have an update query amending information, from tblver to tbltan in the query I want to add something but am not sure if it will work, or if i have the right code.
The field i want to update = CRcode
This sits in table = tbltan
I am updating other fields with the new information coming from = tblyer
Query
Field = CRcode
Table = tbltan
Update to = IIf([tblver].[Rcode] Not "08","",[tbltan].[CRcode]="7")
So i want it so for the records from tblver that we are updating if the field Rcode is anything other then 08 or blank then the field CRcode will equal 7, otherwise nothing happens.
Does this sound right? Have i written it right?
The field i want to update = CRcode
This sits in table = tbltan
I am updating other fields with the new information coming from = tblyer
Query
Field = CRcode
Table = tbltan
Update to = IIf([tblver].[Rcode] Not "08","",[tbltan].[CRcode]="7")
So i want it so for the records from tblver that we are updating if the field Rcode is anything other then 08 or blank then the field CRcode will equal 7, otherwise nothing happens.
Does this sound right? Have i written it right?