grouping records

[icemonster]

how do i group records? let's say, from a tbl with a FK, i want to group all FK of that tbl to the last record? what's the best way to do it?

 

[jdraw]

How about describing the tables and fields and what you really want to group on?

 

[icemonster]

here's the table,
tblschedule

scheduleid
clientid
visitdate
visitstatus

what i want is to group all clientid, meaning that if a client has multiple records, it will only show the last record or max record for that client.