How to Make Access do the work

[NoClue]

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.

 

[Dorian]

Yopur question is very vague... What are the 3 tables? How are they related?
What does your report look like?

 

[NoClue]

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

 

[John W. Vinson]

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... Visio 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 (e-mail address removed).

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.

 

[roccogrand]

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