Two records one row

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

vanderghast

Only two?


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


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update data to match based on like datasets 2
Really need query help!! 2
Combining Records from the Same Table? 1
How do I bring a filed from multiple records and join them togethe 2
set value of txtbox in form = select query 2
QUERY 2
Delete query 2
Group By Query - find which rows are being grouped 3

Top