RE: report that includes multi tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for replying.

There is separate tables for the years because the autonumber is used to
create a new file #. The column before the new file # is the year ie 05 for
2005. When the report is printed it prints 05 - *file #*. In order to use
the auto number and start back at 1 when the next year started a new table
was created. I want to combine the tables in the query so I can sort in my
report by last name and not have to go through each report by year, which is
what they have been doing here for several years. I know there is an easier
way using what they already have.

The next question I have is how to do a UNION instead of a JOIN. When I was
reading through the instructions and asking questions the UNION hadn't come
up so if you could please instruct me I would greatly appreciate it.


"Pat Hartman" wrote:

> 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: Should be simple but...
    ... Staff directory- I need it to list last name, first name, phone location ... I did as you suggested and created a subreport. ... Used the wizard to link the srpt to the main report. ... I have one location that lists 6 staff ...
    (microsoft.public.access.reports)
  • Re: The rebirth of McCarthyism
    ... I don't have any sympathy for any baseball players who've been caught up ... The union has resisted drug testing ever since it's ... How can we tell by reading the report what it ...
    (alt.sports.baseball.bos-redsox)
  • Re: I need a form to select the items to be presented in the repor
    ... Dim strCriteria As String ... change "ReportName" to the name of your report. ... In the report query remove the "Where" clause. ... Instead of a query asking for a site, I want a form which lists all the ...
    (microsoft.public.access.formscoding)
  • SQL Injection: Issue with UNION SELECT ALL
    ... using a UNION SELECT ALL statement. ... an equal number of expressions in their target lists. ... Column 'a.id' is invalid in the select list because it is not contained ... in an aggregate function and there is no GROUP BY clause. ...
    (Pen-Test)
  • Re: Legal action to stop rail strike
    ... fulfil any legal requirements by providing paper lists, ... have to be input every time before the matching exercise could begin. ... The union will know the ... The RMT have the names, addresses and unique employee reference ...
    (uk.railway)