How to obtain the max value from two separate tables

[swb1]

Hi,

I am using Access 2007 and I have two tables (2010 & 2011). There is a common field/column in each table called 'Yearly Total'. I would like to run a query that will return the max value regardless of which table the value is retrieved from (2010 or 2011). Is this possible? If so, can someone explain?

Thanks,

swb1

[June7]

Why do you have two tables? Are the fields identical? If yes, should be one table with another field for the year identifier. Otherwise, build a UNION query and use the UNION query as data source in other queries.

Must have responded to half dozen threads in 2 days that called for UNION solution. Here is one https://www.accessforums.net/queries...ery-45873.html

[swb1]

To answer the question, I imported the data from an excel spreadsheet that had 22 sheets in it. Each sheet imported as a new table. Maybe that was the problem. Is there a way to have all of the 22 sheets imported one time into one table? If so, can someone explain how to do it?

[June7]

Should be able to. Is this a repetitive exercise or just the one-time event? If one-time then data is already in tables, just combine data to one table. The effort to figure out the 22 sheet import will probably be just as much as fixing the already imported data.

[swb1]

You are probably right. Making the adjustments in excel will probably be easier to deal with.