Stuart McLachlan
stuart at lexacorp.com.pg
Sun Nov 23 05:41:09 CST 2008
You need something like: Select Distinct [Date],ax,ay,spec,First(mm),First(vv),First(egg),First(Larf) >From tblMyTable Group By [Date],ax,ay,spec Order by [Date],ax,ay,spec You may want to replace First() with Sum(),Min() or Max() depending on exactly h what you actual data is and what results you want On 23 Nov 2008 at 11:28, Pedro Janssen wrote: > Dear Group, > > can you help me with a query? > > > I have: > > Date ax ay spec mm vv egg Larf > > 01-01-01 123 123 A 1 > > 01-01-01 123 123 A 3 > > 01-01-01 123 123 A 45 > > 01-01-01 345 345 A 1 > > 02-02-02 678 678 B 12 > > 02-02-02 678 678 B 4 > > > > > > i want > > > > Date ax ay spec mm vv egg Larf > > 01-01-01 123 123 A 1 3 45 > > 01-01-01 345 345 A 1 > > 02-02-02 678 678 B 12 4 > > > > > > > > How can i do this in a single query? > > > > Thanks > > > > Pedro > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com