I am trying to combine several duplicate fields into one record. Fields are: VIN(this is the duplicates field), and approximately 30 yes/no fields. I need all the 'yes' fields to over-ride any 'no' fields to combine all the recordsets into one.<br>
<br>
Eg.<br>
<br>
VIN ¦ WC ¦A ¦B ¦C ¦D ¦E...
I am trying to combine several records into one, I have one identification number coming up 1-12 different times, with a unique location subset. (i.e.- ID # 35674, at WC#250,270,290,440)<br>
<br>
I also have several yes/no checkboxes with each record that have to be combined.<br>
<br>
How...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.