Additional Field In Query

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

Below are sample of field in my query

Account Tag1 Tag2 Tag3 FinalTag
123 A n/a n/a A
134 n/a B n/a B
145 n/a n/a C C
156 D n/a n/a D

The challenge is how to add FinalTag field which source data coming from
Tag1/Tag2/Tag3 as per above example.

Thanks
 
Could there ever be a valid case where the account could have multiple
tables?

If you answer No, the solution will be replace the 3 tags with a single
field. Your table will just have these fields:
- Account
- TagNumber

If you answer Yes, then the best solution will be to turn this into a
related table, with fields like this:
- Account
- TagNumber
The account will match one of the numbers in your Accounts table. The tag
number will be a number between 1 and 3. So one account can have multiple
tags.
 
Back
Top