I need an MS Access query that will combine data from two identical fields in two different tables into one field. The two tables are "Payroll_2011" and "Payroll_2012"; and both tables have columns "Name", "Payperiod End Date," and "Amount".
I do not need to concatenate them. Something like FirstName&" "&LastName isn't what I am looking for.
I just want the query to have, for example, Payroll_2011.PPE and Payroll_2012.PPE rolled into one field that I can sort from Oldest to Newest and see their payroll history across the years without having to open multiple tables.
Please help? (Sorry about lack of formatting)