How to filter out a query

[villica]

Hello everyone, I have this sample data

I want to create a query that only outputs
record 1 and record. The criteria is this

field1 is duplicated(00910) but field6 is different for record 1 and 2 (skt5, skt6) whereas record 3 and 4 field 6 are the same.


field1 field3 field4 field5 field6
00910 abcd 00000 295 SKT5
00910 abcd 00000 295 SKT4
01002 defg 01002 155 SKT1
01002 defg 02225 010 SKT1


any ideas please


villica

 

[HarleyQuinn]

On what criteria do you want to choose which record to output if two are similar (only field6 different)?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[villica]

yes only where field6 is diferent

villica

 

[HarleyQuinn]

I understand that, how do you want to decide which of the records to display?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.