Duplicates

oklahoma84

Registered User.
Local time
Yesterday, 22:25
Joined
Jun 5, 2007
Messages
15
I have imported data from excel into 2 separate tables. I made a query using these 2 tables and then from this i made a crosstab. In the crosstab for some reason it duplicates the same information over and over to where 5000 records become over 100,000. What is going wrong?
 
1. What data is in each table?
2. Are there any duplicate fields within each table or just one to link them together?
 
Well the data in each table is the same just for different years. One table has this years data, which i am using the whole table. The 2nd table is prior year spending information, which i am just using one column out of this table. There is no duplicate information in these original tables. It duplicates all information in a record except it inserts a different value for the cell from the 2nd table.
for example
dept a/c amount ytd prior Date
6050 110 50 100 750 1/11/2007
6050 110 50 100 1250 1/11/2007

I don't know if this make sense
 
It makes sense, but you have to have one field that is common throughout the two tables to link on otherwise you will just get a cartesian product (multiply the number of records in one table by the number in the other as it gives you all possible combinations). So, if dept number is the common field then make sure to link by it. If a/c is also common, then link that as well.
 
Ok. How would I link these together? Thank you so much for your help! I am not a computer person!!
 
You go into the QBE (Query By Example) grid (where you build queries) and drag the common field from one table over to the same field in the other table.
 
Ok i did link every field that was common. They still repeat buy now only like 5 times instead of 250 times. Is it something to do with the 5 months. Any other suggestions? Thank you!!
 
Yes, it could have to do with your dates, but essentially it's telling you that you have some variance between the records - they are not exactly the same (unless there still is a field that isn't linked).
 

Users who are viewing this thread

Back
Top Bottom