Join Bytes! (Joanna Epstein) wrote in message news:<6d657ecc.0406180511.5ffce640@posting.google.com>...[color=blue]
>
Join Bytes! (Pieter Linden) wrote in message news:<bf31e41b.0406171934.38ee06b6@posting.google.com>...[color=green]
> >
Join Bytes! (Joanna Epstein) wrote in message news:<6d657ecc.0406171456.4b7aac3e@posting.google.com>...[color=darkred]
> > > I have several tables formatted as follows:
> > >
> > > ITEM #, ITEM DESCRIPTION, PL, JANUARY
> > > ITEM #, ITEM DESCRIPTION, PL, FEBRUARY
> > >
> > > And so on... I need to create a final report that merges all of the
> > > information from these tables to form a tabular report reflecting the
> > > information for all items for each month. However, the items in the
> > > item number field are not identical. How can I make my report include
> > > information for an item that does not appear on all of my tables?[/color]
> >
> > if your tables have the same structure, create a union query and then
> > base your report on that. BTW, if your tables all have the same
> > structure, why are they separate?[/color]
>
> The tables have been exported from several different Crystal Reports.
> The reason they are seperate is irrelevant - I just need assistance
> making a tabluar report with a column for each month. (Also, in the
> future, other information will most likely get added from tables with
> a different format.) When I tried to make a union of these seperate
> tables, the report excluded information that was unique to each table.
> (ie: item numbers that appear in some month but not all.) Any useful
> assistance would be greatly appreciated.[/color]
If you have other fields that are unique to individual tables, but
still want to include this data in your query result, you'll have to
put in a placeholder, like a null, in that column... otherwise your
sets won't be fully union-compatible.
