I have queries as follows:
retail
wholesale
report query1
retail and wholesale have a cardinality relationship to report query1 1:n and 1:1.
I added a field to retail query called descr_code. Because several descr code can be associated with one record, it causes double counting when I run the report. In properties I did a count distinct however I still get duplicates when I run the report. Is there a way to avoid the duplicates. Will I need another query???