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

Split form 0
Autonumber field in Excel that behaves the same as Access 0
Is this possible? 0
Transfer data between two tables 3
Dates In Excel 5
Adding data to MS Access from csv file 0
How to write a query/macro to consolidate data in the same table, anddelete the duplicate one 1
DLookup in Continuous form 0

Top