Need Help with Search in Query

[KRel]

Hello I need help with a query I am trying to create. I have some knowledge of Access but I am no way close to being an expert. Ok I will try to explain:

I have a table that I need to search for values, howevere some of my people have mutliple values. An example has been attached as a pdf file, I had to do this because I could not get the example to display correctly in the text area provided for this forum.



Well thats the problem, please help if you can.

Regards,

KRel

 

[pbaldy]

I think you have a normalization issue with the repeating fields, so you may want to rethink the design, but failing that I think this gets you what you want:

SELECT Name, CType1, RelDate1
FROM TableName
UNION ALL
SELECT Name, CType2, RelDate2
FROM TableName
UNION ALL
SELECT Name, CType3, RelDate3
FROM TableName

From the look of it, you'd want to add a WHERE clause to eliminate the blanks.