How to Make Access do the work NoClue 12/31/2008 4:42:04 PM 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.

RE: How to Make Access do the work Dorian 12/31/2008 5:18:13 PM 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.

RE: How to Make Access do the work NoClue 12/31/2008 6:09:02 PM 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.

Re: How to Make Access do the work John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/31/2008 6:21:13 PM 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]

Re: How to Make Access do the work "Steve" <nonsense[ at ]nomsense.com> 12/31/2008 7:29:51 PM 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.

Stevie is grovelling again "John... Visio MVP" <lancucki[ at ]stonehenge.ca> 12/31/2008 7:38:46 PM "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.

RE: How to Make Access do the work roccogrand 1/1/2009 3:30:02 AM 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.