Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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.

Posted on 2012-04-04
3
Medium Priority
?
317 Views
Last Modified: 2012-06-21
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
Comment
Question by:RichShare
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 37806600
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
 

Author Closing Comment

by:RichShare
ID: 37806624
thank you
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 37807402
Glad I could help
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question