Hi guys,
is it possible to return distinct values in a report where the underlying query returns multiple values - i cant change the query to DISTINCT because it uses an OBE field (photos).
Essentially i am building a report on target species (biological information, distribution maps, photos fo the species etc) for our field guys to take with them, often we will have multiple records of the target species that come through our government database searches that all need to be captured.
So i dont want the a species listed more than once for the report.
A subsequent make table query also wont work with OBE fields, so can i use a distinct clause in report filtering or similar to just return the succinct list of species for the report?
Thanks.