It depends on how you want to look at the data you want compared. When you say you want to 'compare' the two, do you really want to join them or just look at the data "side by side"? If you want to join the two data sets into one - then remember you must have one key unique field to join the two data sets. Let me know more about the problem - if its a joining problem, I'll help you through it...
This might have been covered in training but I can't seem to get it right. I ran a model on a report we have here. I have two monthly summaries. One for October and September, I want to compare the two. Would I need to export one summary to excel then join databases? I tried that and did not get right output. /b[/quote]
This will depend alot on how you want to see data and the original report layout. But one method that often works is to open up both reports together. Then create a calculated field in the table using the expression
[if this doesn't work, maybe the "/" is a "" ]
This creates a column with the file name that can be used this as a key with the display direction set to across in a summary.