Showing 5 fields as one field in query

  • Thread starter Thread starter martinmike2
  • Start date Start date
M

martinmike2

Hello,

Let me explain my question a little: Our personnel can carry multiple
NEC's (Navy Education Certifications). These NEC's are catagorized
using a numeric system. We track up to 5 NEC's in 5 seperate fields
(this is non-changeable), one NEC per field. What I would like to be
able to do is combine those 5 fields in a query to drive a list box to
only show one column with all of the NEC's currently held. This is
going to be a search utility so that we can select the NEC's we want
and then generate a report to show which personnel hold those selected
NEC's.

So, my question is: Is it possible to combine 5 fields in a query but
not affect the table?
 
In a blank field in the query add the fields separated with &.
To add a - between each use [FieldName]&"-"&[FieldName2]
 
A UNION query will give what you want if I understand you correctly.

Something along these lines:

SELECT ID, NEC1 AS Cert
FROM Table1
WHERE NEC1 Is Not Null
UNION ALL
SELECT ID, NEC2 AS Cert
FROM Table1
WHERE NEC2 Is Not Null
UNION ALL
....
 
Back
Top