X
xg
My table looks like this:
recno sem sid last first address
1 3 88-123-4567 Li Jun 345 Fullerton Road
2 3 88-123-4567 Li Jun 345 Fullerton Road
3 2 88-123-4567 Li Jun 432 Gale Ave
4 2 88-765-4321 Wu Shu 123 Colima Road
5 1 88-765-4321 Wu Shu 123 Colima Road
....
....
people listed multiple times. I want to select one record for each person
and I want the highest 'sem'.
So in this case, I want to select recno 1 and 4.
How to construct a query? Sort decending by sem and group all other fields?
Thanks.
recno sem sid last first address
1 3 88-123-4567 Li Jun 345 Fullerton Road
2 3 88-123-4567 Li Jun 345 Fullerton Road
3 2 88-123-4567 Li Jun 432 Gale Ave
4 2 88-765-4321 Wu Shu 123 Colima Road
5 1 88-765-4321 Wu Shu 123 Colima Road
....
....
people listed multiple times. I want to select one record for each person
and I want the highest 'sem'.
So in this case, I want to select recno 1 and 4.
How to construct a query? Sort decending by sem and group all other fields?
Thanks.