Share via

Access 2013 - Report of Query missing grouping fields

Anonymous
2015-06-05T15:26:16+00:00

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!!!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-06-05T17:09:28+00:00

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.

Was this answer helpful?

4 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-06-05T17:23:33+00:00

    You da man! It was because it was 'Long Text'. Thanks!!!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-06-05T16:58:16+00:00

     but when I create a Report based on this Query I cannot group by one of the fields I need to.

    What happens or does not happen as expected?

    Post data example of query output and report.

    Have a look at the "Report Grouping" image I linked to earlier. You'll see that 'ECE OL3 Complete Statement' is absent from the left hand side of fields I can select to group by, but is present on the right hand side where it shows what fields are included in the output of the report. I need to group by the missing field.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-06-05T16:28:19+00:00

     but when I create a Report based on this Query I cannot group by one of the fields I need to.

    What happens or does not happen as expected?

    Post data example of query output and report.

    Was this answer helpful?

    0 comments