Adding a field from a query to my report

[cmolnar]

Sorry, I'm pretty much a novice. Created lots of queries, forms & reports on Access 2003 when I first created the database but now need to add a new report. I added some new fields to an existing query. I'm creating a new report based on an existing report which I've saved. But when I try to add my new fields to the report by dragging them onto the report details section, I get 2 boxes for the same info. I ran the report but all I get from both boxes is the name of the field, not the data. What am I doing wrong?


There must be an easy solution to this but I haven't been able to find it. Help!

[ItsMe]

That does sound odd. What happens if you create a new Unbound Textbox Control and type the name of the field inside the control?

[cmolnar]

Sorry, but I don't know how to do that.

[ItsMe]

From within Design View of your report, you can use the tools from within the ribbon to select a Text Box. When you click your details section, the text box should be added automatically.