RE: report that includes multi tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

For starters you really shouldn't have a separate table for each year. Your
application would be simpler if everything were in one table and you used
criteria to select what you wanted.

In any event, when you want to merge multiple lists, you need to UNION them
which is a different operation from JOIN. Union basically tacks one list on
to the end of another. It's like adding the Stratford white pages to the end
of the Bridgeport white pages. You couldn't join the two lists because
different people live in each town.

"still learning" wrote:

> I need help. I have been using a single table in queries, filters, and
> reports. No problem. I now want to join several tables to generate one
> alphabetized list. I tried joining just two tables in the query to see if
> I'm doing this right and the output is only giving me data from one table not
> both. I can't figure out what I'm doing wrong. The diagram shows joined in
> the desin view.
>
> This is my ultimate desire: I have 6 tables by year 1999-2005. The file #
> is auto generated. The tables include client info (name, address, phone,
> account type, county code #, and misc) The imorportant key is the county
> code #. I want to produce a final report that is alphabetized by client last
> name and includes: file #, name, acct. type, and county code #.
>
> Can anyone help me please. Thanks
.

Relevant Pages

  • Re: report that includes multi tables
    ... I tried joining just two tables in the query to see if ... The tables include client info (name, address, phone, ... > account type, county code #, and misc) The imorportant key is the county ...
    (microsoft.public.access.gettingstarted)
  • report that includes multi tables
    ... reports. ... The tables include client info (name, address, phone, ... account type, county code #, and misc) The imorportant key is the county ...
    (microsoft.public.access.gettingstarted)