Search results for query: *

Wait...wait a second. I hadn't realized that my personkey field had to be defined as a group for your last suggestion to work. I did just that and it seems to be working. Thank you. Don't know why the SQL statement didn't work, though.

I did what you said, lbass, went to (report->selection formula->GROUP) and typed the following: {PersonAddress.RecordSequenceNum} = Maximum ({PersonAddress.RecordSequenceNum},{PersonAddress.PersonKey} ) but when i click on 'save and close' i get the following error: "There must be a group...

I'm really trying to follow you fisheromacse...here's what I typed with the following info: what you call the PersonID, I call PersonKey; what you call yourtable is PersonAddress with me. And we know that the sequence field is RecordSequenceNum. So..... Here is what I typed in the SQL...

Let me explain exactly what I am trying to do. I work for law enforcement in Probation. I want to compile a list of current people on probation. List their name, other info, and the current address. When I add the address fields to the report, i get all the defendant's prior addresses...

I apologize for this lbass, but I am quite the idiot when it comes to this stuff. How do i use your suggestion. Could you point me in the right direction for learning how to apply your suggestions?

Subject says it all. I need to be able to obtain the most current address record of each of our people in our database. Everytime we add a new record, there's a new sequencenumber given to that new entry. I need only the newest sequencenumber. How do i go about requesting this?