I'm a newbie at this. I have a report that uses a field called Last Call from a different table. That table lists all the calls made by a sales person. I want to show just the most recent one (Last Call) in my report, but it shows the first one (oldest). How I get the last one to display (most recent)?

the field Last Call should be a calculated field

Last (table:field)

Hope that helps

I'll look into that (don;t know much, I;m sure it's easy). Should the calculation be done in the table of the last call field or the reporting table? Thanks

the calculated field should be in the table that is related to the calls

So if you have sales people table and a calls table, put the calculated field in sales people.

Have a nice day.

Can you help me with that calculation should be LastCall = ?

Here is a sample file with 2 tables - people and calls

People has the last called calculated field in it.

Please let check it out and see if you have any questions.

Last_Called.fp7.zip

Just a quick 'thanks' for your help; I was able to take you lead and rework on my end and it now produces the report I was after.