INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Group Field Selection Missing Specific Field

Group Field Selection Missing Specific Field

(OP)
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?

Duane
Hook'D on Access
MS Access MVP

RE: Group Field Selection Missing Specific Field

(OP)
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.

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

Resources

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