Right now I am using the demo of the software to see if it can do what I need it to and how the end result will look ... below is what I am trying to do and have met with limited success thus far.
- I have a database with a bunch of competition records. I need it to group the results by state. I figured out how to do this. Now, I need to limit the result from each state to the top 3 results (IE, using state as a primary sorter, then sorting by points, but only displaying the top 3 points for each state.)
- I may require using 2 databases (1 for competitor details, and 1 for competitor results), is there a way i can corelate the information from 1 db to the other (IE, client ID = JOE2008 in client details db, in competition results, the same persons info is store under JOE2008 but there is no name stored. I would want to take the name field from the client details db and use that information in the competition results report.)
Any help is appreciated. So far I love this software, and if it works for what I need I plan to buy it since this will make my life SOOOO much easier.
