How to run report in Access ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I would greatly appreciate any help. I am trying to run a report from
multiple tables. I tried creating a query first to incorporate all data in
it. However, since all my tables have different fields, (except for primary
filed), I am getting duplicate fileds in the query. When I run report, it has
repetitive data. Sorry, if this is not clear enough...

Thanks,

I.
 
Without a better description of your tables and relationships, I can only
suggest using subreports for some or all of your "child" tables.
 
Thanks. I thought so too, but I have difficulties creating the sub reports. I
have 6 tables. First - the main one has all information about the list of
subsidiaries, where the company name is a primary key. Other tables have
additional info about those subs, sometimes two, three or more entries for
one sub... I am totally lost
 
I would expect that you might be using subforms of forms for entering your
records. Subreports work nearly the same as subforms.

Create reports based on the "Other tables". Then add these as subreports on
your main report which is bound to the subsidiary table. Use the Link
Master/Child properties to synchronize the subreports with the value on the
main report.

BTW: In the future, consider using some field other than the "company name"
as the primary key. Company names may change and you may find two companies
with the same name.
 
Back
Top