Two records one row

  • Thread starter Thread starter Marcie
  • Start date Start date
M

Marcie

I have a table that has 2 records per id. I want to display in a query each
value as a record.
So if Id 123 has a record with the value of 7 and another record with the
value of 8 I want a query to display 123, 7, 8.
Is this possible?
 
Only two?


SELECT id , MIN(fieldName), MAX(fieldName)
FROM tableName
GROUP BY id


Vanderghast, Access MVP
 
Back
Top