Showing 5 fields as one field in query

[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?

 

[Simon]

In a blank field in the query add the fields separated with &.
To add a - between each use [FieldName]&"-"&[FieldName2]

 

[martinmike2]

Simon,

I need the NEC's to each occupy a record in the query to fill a list
box.

 

[Allen Browne]

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
....