Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Group Field Selection Missing Specific Field

Group Field Selection Missing Specific Field

hi everyone - I'm working on a technical report that will be using all 10 multi group levels. I'm on the 9th level and for some reason I cannot find the field I need from the drop down list box (see picture attached). I checked the underlying query and the field is definitely part of the SQL query and also double checked as datasheet to make sure the end result did include data from this missing field (all good there).

Am I overlooking something obvious?? Any suggestions as to what to look for would be appreciated.
thank you

RE: Group Field Selection Missing Specific Field

How are we to know the field that is missing. Is it a memo field?

Hook'D on Access
MS Access MVP

RE: Group Field Selection Missing Specific Field

Hi dhookom
I think you're on to something. I made this field a LONG TEXT. Thanks for pointing that out. Cheers!

RE: Group Field Selection Missing Specific Field

You can't sort on a long text field. You can possibly create a new column that is the left 255 characters of the long text field.

Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close