Ask a new question

Access 2013 - Report of Query missing grouping fields

Hi - I'm new to Access and help would be appreciated. I have a Query whose output is correct, but when I create a Report based on this Query I cannot group by one of the fields I need to.

Query Design: http://i.imgur.com/fP26Fpe.jpg

Query Output: http://i.imgur.com/PcwiRpg.jpg

Report Grouping: http://i.imgur.com/NmdAuLm.jpg

   I need to also (most importantly...) be able to group by "ECE OL3 Complete Statement". Any idea why I can't? Does it have something to do with how the Joins are set up? For now I have to export to Excel and do a Pivot Table which is just a stop-gap measure.

Thanks!!!

Answer
Answer
Is the ECE OL3 Complete Statement column of Long Text (aka Memo) data type by any chance?  I think I'm correct in saying that it is not possible to group by a column of this data type.  What you might be able to do in this situation is return a fixed number, up to 255 I think, of initial characters from the value in a computed column in the query the value by means of the Left function, and group by the computed column.  The Long Text column's data could then be returned in a group header or footer.  You'll need to amend the design of the report manually to do this, however.  The report wizard will only get you so far.
________________________________
Ken Sheridan,
Newport, Shropshire, England

"Don't write it down until you understand it!" - Richard Feynman

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 14, 2025 Views 2,087 Applies to: