Too much data

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Every week I receive a mdb file from one of our large
plotters. It is a log of each print job sent and contains
four predefined tables. Three of the tables have the
exact same number of records and therefore the exact same
keyid's. The problem is with the fourth table, it splits
the job differently and I end up with additional records
(700 this week). I need one column of data from the
fourth table to finish my report but I can't use the
keyid to link it. The fourth table does have a jobid I
could use but there are multiple records with the same
jobid. If I can combine the multiple jobid records into
one record then I will be able to link the fourth table
properly. How do I do this? Thanks.
 
Perhaps you need a separate table in your own database for that information.

HTH
- Turtle
 
Back
Top