ohucan2 Posted September 17, 2007 Share Posted September 17, 2007 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)? Link to comment Share on other sites More sharing options...
agtjazz Posted September 17, 2007 Share Posted September 17, 2007 the field Last Call should be a calculated field Last (table:field) Hope that helps Link to comment Share on other sites More sharing options...
ohucan2 Posted September 18, 2007 Author Share Posted September 18, 2007 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 Link to comment Share on other sites More sharing options...
agtjazz Posted September 18, 2007 Share Posted September 18, 2007 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. Link to comment Share on other sites More sharing options...
ohucan2 Posted September 19, 2007 Author Share Posted September 19, 2007 Can you help me with that calculation should be LastCall = ? Link to comment Share on other sites More sharing options...
agtjazz Posted September 19, 2007 Share Posted September 19, 2007 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 Link to comment Share on other sites More sharing options...
ohucan2 Posted September 21, 2007 Author Share Posted September 21, 2007 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6154 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now