Display latest entry ina field

[ohucan2]

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)?

[agtjazz]

the field Last Call should be a calculated field

Last (table:field)

Hope that helps

[ohucan2]

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

[agtjazz]

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.

[ohucan2]

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

[agtjazz]

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

[ohucan2]

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.