Report From Table - Unique Records in Several Tables

[Joanna Epstein]

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?

[Pieter Linden]

jo***********@yahoo.com (Joanna Epstein) wrote in message news:<6d**************************@posting.google. com>...

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?

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?

[Joanna Epstein]

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

jo***********@yahoo.com (Joanna Epstein) wrote in message news:<6d**************************@posting.google. com>...

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?

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?

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.

[Pieter Linden]

jo***********@yahoo.com (Joanna Epstein) wrote in message news:<6d**************************@posting.google. com>...

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

jo***********@yahoo.com (Joanna Epstein) wrote in message news:<6d**************************@posting.google. com>...

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?

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?

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.

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.