5 Replies Latest reply on Apr 10, 2009 9:38 AM by philmodjunk

    Comparative find



      Comparative find


      I need to compare two finds side by side.  I can do the finds, examples 4/01/2008...4/15/2008 and another find of 4/10/2009...4/01/152009.  I can save the finds and look at them individually, but I would like a combined look.  

      I have done the find 4/01/2008...4/15/2008 OR 4/10/2009...4/01/152009, but I just get the list of all those dates and cannot find a way to separate them to view the years and information side by side 

        • 1. Re: Comparative find

          I am not sure what exactly is involved in this comparison, but you cannot have two found sets in the same window. So one way to do this could be to open a new window.


          Another option is to use two relationships, with a pair of start/end dates for each.

          • 2. Re: Comparative find

            Just to throw in another possibility, you might be able to use sub summary layout parts to separate your two groups of found records into two subgroups on the same list view layout. If you have FMP 10, this will be pretty nice as you can see these parts in browse mode where you would have to preview or print the layout to see them in earlier versions.


            As comment said, describe in more detail so we can help in more detail. (If comment's excellent suggestions turn out to be the way to go, I'll bow out and let you two go at it.)

            • 3. Re: Comparative find


              The new window was a quick and easy solution.  I am going to try the relationships with start/end dates this weekend.  

              This is what I am doing.  I use FM to keep track of my cycling workouts; date of rides, miles ridden, avg. MPH, time ridden, ect.  I have a calculation field set up to total the miles ridden.  I like to compare months from different years.  What I was wanting to see or set up was a find that would allow me to see the information collected from the month of April 2008 and compare it to the information being collected for the month of April 2009.    

              • 4. Re: Comparative find

                DA wrote:

                I like to compare months from different years.

                If each of the compared groups will ALWAYS have some distinguishing attribute (such as month or year), you could indeed find them both and produce a summary report.

                • 5. Re: Comparative find

                  I've created a 5 year comparison report for some of my solutions. Each Row is a different month and each column is a different year. Just to clarify your request, how close does that come to what you want?