Layout help please!!!

[Ronzues]

Can someone offer me some insight on this? I have an 'Artist" database that I have included in this post. There are 2 layouts, "Artists". and "Artist Report".

When you enter data in the "Artists" layout it then displays the spins in a column on the "Artist Report" layout as well as the week ending data in the header for that Artist. As we enter new records we date them exactly 7 days apart. What I would like to do is to get the "Artist Report" to display not only the current week ending date and current spins, but also the previous week ending data and the previous weeks spins. I want to be able to do a find for a particular artist, then go to the "Artist Report" layout and see this weeks ending date like I do plus see the previous week ending data in the header to the left of the current week ending date, plus see a previous weeks spins in a column to the left of the current weeks spins. Of course all of this info would need to be pulled from previously created records. Can someone point me in the right direction because I have been racking my brain on this one.

Ron

Artists Copy.fm5.zip