Help Please

I have:

F1 F2 F3
1 12Oct 2:14
0 12Oct 2:14
0 13Oct 1:15

when is the same day and time I would like a condition that shows just the
record with value in F1 - keep record number 3 and 1

Big Thanks

Dan

Select F1, F2, F3 FROM tablename GROUP BY F1, F2, F3

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"D" wrote in message
...
I have:

F1 F2 F3
1 12Oct 2:14
0 12Oct 2:14
0 13Oct 1:15

when is the same day and time I would like a condition that shows just the
record with value in F1 - keep record number 3 and 1

Big Thanks

Dan

I think that the solution proposed is on the right track except for one missing bit.

SELECT Max(F1) as F_1, F2, F3
FROM TableName
GROUP BY F2, F3

I think the proposed solution would still return all three records.

"[MVP] S.Clark" wrote:

Select F1, F2, F3 FROM tablename GROUP BY F1, F2, F3

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"D" wrote in message
...
I have:

F1 F2 F3
1 12Oct 2:14
0 12Oct 2:14
0 13Oct 1:15

when is the same day and time I would like a condition that shows just the
record with value in F1 - keep record number 3 and 1

Big Thanks

Dan