Subreports of queries from different tables

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

Guest

i have a main report with a few subreports of some queries of different
tables.
queries have the information about workers. i want a report where i will
see all info of the person (which will come from different queries).
i have finished main report and subreports, everything works fine, the only
problem is i have to enter the worker name for each sub report to bring his
datas to report.

since i want information of one person i just need to type worker name once
for report and all subreports. can this be done in reports or do i have to
look for the solution in one big query?

Thanks, greetings from switzerland
 
Greetings!

what kind of a database do you have? What does it keep track of? How
many tables are you using?

Queries are used to gather information from multiple tables but all the
data is stored in tables. It seems that your reports should be able to
be set up so the subreports are linked to the main report without
entering the worker name for each subreport -- I suspect that your
subreports are based on parameter queries and that is why you are being
prompted.

Check into the

LinkMasterFields
LinkChildFields

properties for subreports (and subforms)


send me an email and request my 30-page Word document on Access Basics
(for Programming) -- it doesn't cover VBA, but prepares you for it
because it covers essentials in Access.

Be sure to put at least "Access Basics" in the subject line so that I
see your message...

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Thanks for the quick reply Crystal,

access 2000, tables contains numbers, text and date together. 6 different
tables.

yes, all the queries bring the data of one asked person.

ok i will send you an email as soon as possible. Thank you very much.

wish you a very nice day.

vepha
 
Hi Vepha,

Did you get the document I sent?

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top