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.