Re: Connecting to the Same Table Twice

Hi there -

Thanks, tina, for your input. You saved me a lot of (my precious valuable)
time!!

OK, another question, if you would be so kind. I think I know what to do,
but I would like your approval.

The report should look like this --
Info from tblChild
Info from query tblChild tblRelationships tblAdult
Info from query tblChild tblClass

The way I see it -
the basic child information,
all his relationships (e.g. parents, nanny, emergency contact, doctor)
the child's schedule of classes (they may go 3 mornings a week or 5
afternoons etc.)

So...question is...

Can I put these 3 reports into one. I am pretty sure I can, but I have
never done it before. I think I read about it somewhere.
(All I have done before is make reports from 1 table or a header table and a
details table.)

I think all the info would fit onto one page, but I see the info comes from
3 different sources. What is the best way of doing this?

Thanks !!! !!!

Joy






.

Relevant Pages

  • Re: Connecting to the Same Table Twice
    ... reports are not my strongest area - i can usually figure out how to ... grouping on the ChildID field. ... > Info from query tblChild tblRelationships tblAdult ... > the basic child information, ...
    (microsoft.public.access.gettingstarted)
  • Re: Some text isnt recognized in reports query
    ... Gee, thanks, Tina. ... This is the first newsgroup I've ever joined (a couple of ... days ago, in fact), and this was the first posting I've ever made to one ... related to both queries and reports, and because I didn't know of any ...
    (microsoft.public.access.reports)
  • Re: Print a report from the switchboard
    ... Hi Tina, ... i think best is to use Print Preview toolbar print button. ... my own toolbar, and use it for all reports, so user open report in preview ... >>> I've created a switchboard that opens reports. ...
    (microsoft.public.access.devtoolkits)
  • Re: New Day/New Outlook
    ... I have finally gotten quite a bit of sleep, and fluids and while I still feel unreasonably tired - my outlook on things has improved immensely. ... Tina and family ... I'm still trying to put together a mental picture of everything that happened and is still happening--so many different reports, viewpoints, etc. I'm interested in the death toll you described for the evacuation. ...
    (rec.crafts.textiles.quilting)
  • Re: Print a report from the switchboard
    ... Tina wrote in message ... > I've created a switchboard that opens reports. ...
    (microsoft.public.access.devtoolkits)