timolous 0 Posted May 14, 2001 I need have MS Acces like 'group by' command to use with Filemaker.Valuelist is not for me, becouse I need to group by after find. ex. records are: 2 13 23 33 3 33 1find finds with '3'. Result should be like this: 13 23 33 3But with filemaker it's: 13 23 33 3 33 I don't wan't dublicates to on my result.... Is it possible to Group By with Filemaker?ODD_Clone.fp7.zip Quote Share this post Link to post Share on other sites
Kurt Knippel 0 Posted May 14, 2001 quote:Originally posted by Timo Lehtinen: I need have MS Acces like 'group by' command to use with Filemaker. I don't wan't dublicates to on my result.... Is it possible to Group By with Filemaker? It is called a SubSummary, when you set the report to "sub-summarize by" that particular field. Then since you only want to see the grouped data, you would remove the "Body" leaving only the Header, Footer and Sub-Summary parts. Quote Share this post Link to post Share on other sites
timolous 0 Posted May 15, 2001 Yep. That helps if I want' records to show up on Filemaker. But I wan't it really like Ms acces like (SQL like group by). I need to have founded records as many as there are unique records. I need this result on Web.I tryed Even Filemakers ODBC connection. It worked out for me, but very slowly... I Need speed, becouse find result will be part of web portals functions..... Quote Share this post Link to post Share on other sites
Kurt Knippel 0 Posted May 16, 2001 quote:Originally posted by Timo Lehtinen: Yep. That helps if I want' records to show up on Filemaker. But I wan't it really like Ms acces like (SQL like group by). I need to have founded records as many as there are unique records. I need this result on Web.I tryed Even Filemakers ODBC connection. It worked out for me, but very slowly... I Need speed, becouse find result will be part of web portals functions..... Sort the records, then loop through them, omitting all duplicates. Do this via a script. It is possible that this is more of a problem with the design of the data structures if you have alot of duplicate records. Or you might need to make changes to your structure in order to make this easier. Quote Share this post Link to post Share on other sites
ro 0 Posted October 20, 2001 Originally posted by Timo Lehtinen: [QB]I need have MS Acces like 'group by' command to use with Filemaker. Quote Share this post Link to post Share on other sites
ro 0 Posted October 20, 2001 Originally posted by Timo Lehtinen: [QB]I need have MS Acces like 'group by' command to use with Filemaker.I'm trying to do something similar. I have survey answers stored in one file like this:address city countryI want to count the number of records for each country and display like this:country1: 2345 country2: 1356 country3: 45 etc..I was able to come close, but I basically have to go through 2345 records until I found out the numbers for country2.The "group by" feature requested by Timo Lehtinen is what I'm thinking about, but is this possible with FM? Quote Share this post Link to post Share on other sites
Kurt Knippel 0 Posted October 21, 2001 Again, this is possible. It is called a sub-summary. Specifically you are sub-summarizing by Country. However this is a reporting function and not a normal browse function.What is occuring with the Access application is that it is applying a SQL Group By function, which basically creates a NEW table where only the summarized value are displayed.This is possible in Filemaker via an Export/Import procedure into a duplicate file, where you only export the summarized data. I have done this for reporting purposes and generally it is pretty quick.I do not know your exact needs, but with Filemaker just about anything is possible and it certainly has more possibilities that Access. Quote Share this post Link to post Share on other sites
ro 0 Posted October 21, 2001 Thanks. That worked. However everytime the data in the original file is updated, you have to export again for each summary you do. A bit clunky. Quote Share this post Link to post Share on other sites