Data Blending Using Access

[soumya]

I have my data for a particlaur month divided in 2 different access databases. Both the Access Databases have the excat same fields and I am using the uniron function to connect the 2 databases and then use a summarize function to get the media cost but it's doubling up the numbers. How can I fix this issue? 

[jdunkerley79 · Accepted solution]

I am guessing there is some duplication in the data.

I would suggest you use a unique tool after the union tool to pick out a unique set of data.