adding field to report

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

When using the inventory template, in the product summary
report it defaults to product name, # in stock, etc.

All I want to do is include the Product Description in
that Product Summary, but I have not been able to figure
out how to do it. HELP?

thank you
 
Go into Design view of the report. Click the dark grey area just under the
report page. Click the Properties button on the toolbar.
If you've clicked in the right area it will say Report at the top of the
box.

Click on the Data tab and click just to the right of the box next to Record
Source.

This will open up the query on which the report is based. In the grey area
above the query grid you will see the Products table. You will see the
ProductDescription field listed there. Click on this and drag it down into
the white query grid.

Click the x in the top right corner to close the query. Say yes when asked
if you want to save the changes you made.

Find the Field List button on the report toolbar. You will now see Product
Description listed there.

Click on the word and drag it onto the Detail area of the report.

Does this help? If not, ask again.

PS if you are new to access there is an excellent group called
microsoft.public.access.gettingstarted You might enjoy reading some of the
messages in it.

Evi
 
Evi, I don't know if you'll see this or not, but THANK
YOU!!!!! I spent so much time trying to figure it out and
you saved me in a few minutes of effort. Thank you.
 
Glad it worked :)

Happy Databasing

Evi

Jeff said:
Evi, I don't know if you'll see this or not, but THANK
YOU!!!!! I spent so much time trying to figure it out and
you saved me in a few minutes of effort. Thank you.
Click to expand...
 
Back
Top