"Group By" & "Can Grow" - How to resolve conflict?
Posted on 2003-10-29
I'm trying to generate a report with my database and I would like to have the capabilities of the "Group by" within my query to merge together similar pieces of information. Note that I have memos in my query and hence I can not use the "unique values" property to weed out redundance.
Within my report, I have fields that I want to specify "can grow" and "can shrink" to accomodate for varying memo fields' sizes. However, "can grow" and "can shrink" do not work when "group by" is activated in a query (AFAIK).
Any easy solutions out there?