Query Multiple Results

[subtilty]

Hi All,

I need help with a query,

I am using Design View to create a query to find all fields of CC and HR value.

Per Record there is 1 CC field, but multiple HR fields. How would I be able to have it so it brings back just the CC field and the last updated HR field?

Thanks,
James

 

[boblarson]

Sounds to me that you have a normalization problem. You should not have more than one HR field in the table. You should be adding RECORDS not columns. Then a query is a breeze. Looks like it might be time to do some design changes before moving further along.