• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

The field i use to gorup by on a wizard generated report in access database shows the ID not the text. When the field is used not as a group it works fine. I am a novice access user. Please help.

Using Access 2007 on Windows XP.
The table is drawn down from a sharepoint list, the field in question is a lookup in List 1 from a second sharepoint list (List 2). Hope that makes sense.
0
RichShare
Asked:
RichShare
  • 2
1 Solution
 
Dale FyeCommented:
I generally group by the ID fields, and the report wizard will generally only put that ID field in the group, but you can drag other fields that are associated with the group into the group, and reposition them as you feel appropriate.

I also generally move the ID control to the right side of the report and hide it (field (set it's visible property to false).
0
 
RichShareAuthor Commented:
thank you
0
 
Dale FyeCommented:
Glad I could help
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now