Whenever you have repeating fields like that, you need to break the table
up. Lose all those fields. Instead create a related table, with fields:
This table links between the employees and the assets. There is now only one
field to choose.
That's going to be much easier and more efficient than a monster UNION query
that combines selected each asset from each column into one big column so
you can then select and dedupe them, and still not have a maintainable
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.