From: PieterLinden via AccessMonster.com on
SELECT UniqueColor.readname, UniqueColor.colour, UniqueColor.number, First
(UniqueColor.height) AS FirstOfheight
FROM UniqueColor
GROUP BY UniqueColor.readname, UniqueColor.colour, UniqueColor.number;

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1

 | 
Pages: 1
Prev: Friday's Due Date
Next: SQL subsets