Printing notes in report

[mcbaker]

Hello,

I have been working with Access 2003 for only about a month, and I think I
understand the basics pretty well. However, I am having difficulty with a
couple of items:

1. I have a table listing the details of projects, and I wish to include in
a report any comments and notes pertaining to the specific project. No
matter how I try, I cannot get the report to include the comments. I
prepared a subform of the comments, and I only see the notes related to a
specific project when I open the main form. Any ideas on what I might be
doing wrong?

2. I have a combo box linked to another table and it displays fine in the
form, but when I run a report, I get a number instead of the name on the
field.

Thanks for whatever help you can offer...

 

[Jeff Boyce]

Take a look at using a query as the source for a report, rather than relying
directly on a table. You can create a query that joins the projects and
their respective notes.

By their nature, comboboxes typically display a more user-friendly field
while using/preserving the rowID of the value displayed.

If your query points to the combobox, chances are it points to the rowID!

That said, the kind of confusion you describe often happens when someone
uses the so-call "feature" of the "lookup" data type in a table definition.
Having a table show one thing but store something else sounds like a recipe
for trouble!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Steve]

Hi Judy,

1. Does your table include a comments field or are your comments in a
separate table. If the latter, you need to create a query that includes both
tables and set the recordsource of your report to that query.

2. In the query in 1, you need to include the table your combobox is
linked to and make the field you want to display from the combobox a field
in the query.

Steve

 

[mcbaker]

Ok, you guys are both talking a bit over my head...queries are not my strong
point, but I will give it a try and report back to you my success.

Thanks again.