This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have this list of fields needed to be on the report. Note that the last field I added is "LANTHI".
The grouping setting.
At this step, choosing "Stepped" layout causes the problem. The "Outline" and "Block" layout work just fine.
This is the result. You can see that there is no textbox or label for the field "LANTHI".
The field "LANTHI" is also nowhere to be found in the Property sheet.
I only modified the Report Wizard in steps shown above, leaving the others default.
The source query is just a simple query to retrieve the needed fields. I have also tried adding the fields directly from the tables, but the result is still the same.
A family of Microsoft relational database management systems designed for ease of use.
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.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Try add a text box and then drop down the Control Source property to see if your field is there. Most of us seasoned developers rarely use the wizard so we aren't familiar with its limitations.
Let's see BOTH the underlying table and the SQL for the query used in this report, please.
Here's what we're thinking.
The new field was added to the table. However, the new field was NOT added to this query. Therefore, it's not available to the report which is bound to the query.
Showing us the details will help confirm the guess.
This is a database supplied as part of a school course? Was the query already created? Can you provide the SQL for the query?
Thank you for your reply! I have tried both Quick and Online Repair option but the problem is still there. Just asked 2 of my classmates who are working on the same database and they also encounter this.
Hi Spy, I will try to help.
I suspect a problem with the Report wizard and would try to Repair Office to see if that helps. The fact that it works with the other layouts enforces that.