"Group By" & "Can Grow" - How to resolve conflict?

Hi all.

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?
ExMDIAsked:
Who is Participating?
 
SpazMODicCommented:
PAQed, with points refunded (125)

SpazMODic
EE Moderator
0
 
HaydnHCommented:
"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)."

Really? I'm going to have to try this...

Haydn.
0
 
jadedataMS Access Systems CreatorCommented:
Hey jswan!

 The behaviour you describe may not be doing as you have stated.  There is no connection between the two objects that would cause this.
 What you should do however is set the size of the report control to it's minimum height requirement and simply set CanGrow to true.

regards
Jack
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
peter57rCommented:
'the capabilities of the "Group by" within my query to merge together similar pieces of information.'

You aren't imagining that records will somehow be merged together (data from tha same fields in more than one record 'joined'  together) are you?

If you have a memo field in your Groups query you would usually use 'First' or 'Last' for the Total row.

Pete
0
 
ExMDIAuthor Commented:
peter57r: No, I know the records won't get merged together in a record or table or whatever.  What I meant was in terms of displaying information in a report; such that common information would only show once.

jadedata:  I may be concluding the wrong thing from what I'm seeing within my databse.  However, in my report, when I disable the "group by" within my query (by turning off the totals row) my "can grow" fields in my report work fine.  When I enable the totals row, the field in my report ceases to grow to the appropriate length.
0
 
HaydnHCommented:
In that case - remove the "group by" statement in your query and add grouping (sorting & grouping button) on the report itself.

Haydn.
0
 
ExMDIAuthor Commented:
HaydnH:  I've tried that, but redundant data gets listed.  I've tried to 'hide duplicate data' but the space allocated for the duplicate data remains (ie there are gaps in between data)
0
 
jadedataMS Access Systems CreatorCommented:
Also include a SELECT DISTINCTROW to hide the duplicates,... but with this you risk making the underlying recordset NON-editable.
0
 
ExMDIAuthor Commented:
I have solved the problem through the usage of a sub-report which will allow me to link to a separate query which bypasses the "group by" for the memo field.
0
 
stevbeCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ with points refunded

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

stevbe
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.