I am proficient in most software but have very limited experience with Access. My question is this. Say I have a table for several months containing data in the following format: Jim RRR 2000 A Bob BBB 1500 B Joe RRR 1000 O Kim BBB 2500 A And note that aside from the name, all of the other fields can change on a monthly basis. So I want to create a new table to analyze those monthly changes for Bob in the following format: Mar-06 BBB 1500 B Apr-06 BBB 1700 A May-06 RRR 1800 A Jun-06 RRR 1750 B Is there a (relatively) easy way to do this in access? The data files I am working with are not as simple as these, containing thousands of rows.

maybe if u give me an example on first table and second table and how the result should looks like..

EXAMPLE. I have the following two tables. NAME: March 2006 Jim RRR 2000 A Bob BBB 1500 B Joe RRR 1000 O Kim BBB 2500 A NAME: April 2006 Jim BBB 2500 B Bob BBB 1100 A Joe BBB 1200 A Kim RRR 2300 O I WANT a monthly summary on Bob so I want the new table to look like this: Mar-06 BBB 1500 B Apr-06 BBB 1100 A Hope this helps.