Yes you can but it gets tricky. If you want to bring in more data from
another table you have two options. You can delete and rebuild the report
with a wizard and select every thing you want by choosing individual fields
from multiple tables or queries. This probably not the best option. Option
number two if you go into your report in desing view and right click on the
little box in the top left corner with the black square in it you can go into
the properties for the table. If you select to tab data you will see record
source and the table you are currently using for your report beside it. if
you click on the the little box that comes up beside it that will bring up
the query builder in which you can add tables and individual records by
dropping them into the query. You will have re-add all of the things you
originally had as well, because doing this changes your record source to a
query instead of a table. To add tables to your query go to the query menu
and choose show table. Select each table you want to see something from and
click add. The drag and drop each field you want to see into a new column in
the query. This way you will not lose your original report design, and the
new fields you want to see will be in your field list and you can add them as
you choose. Hope that helps
