Comparing within group by

[hiasen83]

i am completely new to sql , and i`m self teaching so please pardon my ignorance.

I have a table like

name1	group1	value1
name2	group1	value1
name1	group2	value1
name2	group2	value2
name3	group2	value1

if the values in the 3rd col are consistent within a group i want to output the first row, if they are inconsistent within the same group , i want to output the first row with a value that says 'missing'

So my output will look like

name1	group1	value1
name1	group2	missing

How do I compare values within the same group? thanks for helping.

[June7]

Not easy. Consider:

Query1
SELECT First(Table1.Field1) AS F1, Table1.Field2, Table1.Field3
FROM Table1
GROUP BY Table1.Field2, Table1.Field3;

Query2
SELECT First(Query1.F1) AS F1A, Query1.Field2, First(Query1.Field3) AS F3A, Count(Query1.Field3) AS CountF3
FROM Query1
GROUP BY Query1.Field2;

Query3
SELECT Query2.F1A, Query2.Field2, IIf([CountF3]>1,"missing",[F3A]) AS Data FROM Query2;