Jump to content

select distinct


Curtis_B
 Share

This topic is 5769 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm hoping to do the sql equivalent of 'select distinct' in a filemaker find. I'm in version 7. I know I could write a script to give me distinct values, but I would hope this is a built in function. The manual makes no mention of such functionality. Thanks

Link to comment
Share on other sites

  • 2 weeks later...

It depends on how you'll use the values. If they're for a report, you can use subsummaries to show distinct values. If you need a list of values in a form, you can define a value list showing the field you need then use ValueListItems() to display it. Or, if you actually want to find only one record ("copy") of each value then you still have to use a script to do it.

I too yearn for some sort of simpler Select Distinct... capability.

Jeff

Link to comment
Share on other sites

This topic is 5769 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.