Forum Discussion

BarbaraAlvarez1

Qrew Member

3 years ago

Return only one occurrence into a table report from multiple occurrences in a table.

I have a table that has, for simplicity, a client name, related agency, related product and price. One client can have many related agencies, and the agencies may have 1 to 5 products (all 5 are t...

Qrew Trainee

3 years ago

There are more complicated solutions which involve Formula Queries, but have you tried making a Summary Report?

------------------------------
Steven Shweky
------------------------------

BarbaraAlvarez1
Qrew Member
3 years ago
I didn't think of that! The summary report gives me exactly the results what I want, BUT, it is only allowing be to include 5 'then by'. I need to include about 4 more more 'Then By' in my Group By. Possible?

------------------------------
Barbara Alvarez
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  Ah right, the limit is 6 group bys. The only other option is to make a few concatenated fields to join two or more text fields together. Would that work?
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
- BarbaraAlvarez1
  Qrew Member
  3 years ago
  I could create more than one summary report to include the group by(s) that I'm missing. The end results of this report(s) - I will export to a spreadsheet and use as data to populate another table. So I think this will solve the problem. You can still provide other suggestions! Thank you
  
  ------------------------------
  Barbara Alvarez
  ------------------------------