|
|
I need to create a query which can collect data from 3 unquie imported tables
and consolidate the date into one report.
I am trying to track shipment status from 3 carriers. Currently, the data is
manually entered 3 reports, then a query is used to sort by shipment delay
codes. I would like to import the reports directly into the database, then
create a quiry to consolidate the delayed shipments into one table.
The reports have basicially the same information but the data field name are
not exactly the same.
|
|
Yopur question is very vague... What are the 3 tables? How are they related?
What does your report look like?
--
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
"NoClue" wrote:
[Quoted Text] > I need to create a query which can collect data from 3 unquie imported tables
> and consolidate the date into one report.
>
> I am trying to track shipment status from 3 carriers. Currently, the data is
> manually entered 3 reports, then a query is used to sort by shipment delay
> codes. I would like to import the reports directly into the database, then
> create a quiry to consolidate the delayed shipments into one table.
>
> The reports have basicially the same information but the data field name are
> not exactly the same.
|
|
The tables are shipment status reports from 3 carriers. All tables contain my
outstanding shipments. The reports have data such as shipper name, ship date,
tracking number, customer name, due date, etc. I need to consolidate info
into one table so I can run a quiry to sort out which are delayed (not
delivered).
The data (as seen in the example below) would need to be imported weekly,
the goal is to create a late shipments report which includes all carriers.
Example:
AB Trucking Company-outstanding shipments
Shipper Ship Dt Tracking # Customer Due Dt
Vendor1 12/12/08 123456 Jane Doe 12/15/08
Vendor2 12/1/08 546897 Joe Smith 12/8/08
Vendor3 12/9/08 734698 John Ray 12/12/08
"Dorian" wrote:
[Quoted Text] > Yopur question is very vague... What are the 3 tables? How are they related?
> What does your report look like?
> --
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "NoClue" wrote:
>
> > I need to create a query which can collect data from 3 unquie imported tables
> > and consolidate the date into one report.
> >
> > I am trying to track shipment status from 3 carriers. Currently, the data is
> > manually entered 3 reports, then a query is used to sort by shipment delay
> > codes. I would like to import the reports directly into the database, then
> > create a quiry to consolidate the delayed shipments into one table.
> >
> > The reports have basicially the same information but the data field name are
> > not exactly the same.
|
|
On Wed, 31 Dec 2008 08:42:04 -0800, NoClue <NoClue[ at ]discussions.microsoft.com>
wrote:
[Quoted Text] >I need to create a query which can collect data from 3 unquie imported tables
>and consolidate the date into one report.
>
>I am trying to track shipment status from 3 carriers. Currently, the data is
>manually entered 3 reports, then a query is used to sort by shipment delay
>codes. I would like to import the reports directly into the database, then
>create a quiry to consolidate the delayed shipments into one table.
>
>The reports have basicially the same information but the data field name are
>not exactly the same.
It *sounds* like you need to either run Append queries to append the status
data into a single table, or (if you have good reason to keep three separate
tables for "the same kind" of data) a UNION query. See the online help for
UNION to see if that gets you in the right direction... otherwise post back
with a bit more detail about your table structure.
--
John W. Vinson [MVP]
|
|
I provide help with Access applications for a reasonable fee. I specialize
in solving problems like yours. I can provide you a solution for a modest
fee. Contact me at santus[ at ]penn.com.
Steve
"NoClue" <NoClue[ at ]discussions.microsoft.com> wrote in message
news:A285C657-CFF5-461A-BD4E-E2754ADFE1CA[ at ]microsoft.com...
[Quoted Text] >I need to create a query which can collect data from 3 unquie imported
>tables
> and consolidate the date into one report.
>
> I am trying to track shipment status from 3 carriers. Currently, the data
> is
> manually entered 3 reports, then a query is used to sort by shipment delay
> codes. I would like to import the reports directly into the database, then
> create a quiry to consolidate the delayed shipments into one table.
>
> The reports have basicially the same information but the data field name
> are
> not exactly the same.
|
|
"Steve" <nonsense[ at ]nomsense.com> wrote in message
news:pbOdnVm74OGtVcbUnZ2dnUVZ_qTinZ2d[ at ]earthlink.com...
[Quoted Text] >I provide help with Access applications for a reasonable fee. I specialize
>in solving problems like yours. I can provide you a solution for a modest
>fee. Contact me at santus[ at ]penn.com.
>
> Steve
These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is a known troll who is known for causing problems rather than
solvingthem.
John... Visio MVP
Please do not feed the trolls.
|
|
Please tell us what is the form of your reports. Are they in Access, Excel,
Word, or in another form? If they are not in Access, do they have headers
(Excel) or surrounding text (Word)?
David
"NoClue" wrote:
[Quoted Text] > I need to create a query which can collect data from 3 unquie imported tables
> and consolidate the date into one report.
>
> I am trying to track shipment status from 3 carriers. Currently, the data is
> manually entered 3 reports, then a query is used to sort by shipment delay
> codes. I would like to import the reports directly into the database, then
> create a quiry to consolidate the delayed shipments into one table.
>
> The reports have basicially the same information but the data field name are
> not exactly the same.
|
|
|