Please help!!

[Ronzues]

I have placed this in a couple of different topics and haven't heard back. I know I shouldn't do this and I won't in the future but I am kinda worried because I need to find a solution fast.

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

[andygaunt]

OK,

I havent had a chance to download your files (having some issues!) You can email me them off list to make this easier.

So this is pure guesswork on what you have to what you want.

You search for a date range (for this week). You then want to show a report of this week plus last week.

Do you have a field in your database to calculate the week number for the date (plus the year too, otherwise you will end up with the same week from last year)

Something like - zc_WeekAndYear

WeekofYear(Date) & ":" & Year(Date)

result of text, where date is your date field to query.

then you will want to have a small script to find your records for this week and last

Enter Find Mode [no pause, no restore]

Set Field ["zc_WeekAndYear", " WeekofYear(Status(CurrentDate)) &":" & Year(Status(CurrentDate)) "]

New Record/Request

Set Field ["zc_WeekAndYear", " (WeekofYear(Status(CurrentDate)) -1) &":" & Year(Status(CurrentDate)) "]

Perform Find [ no restore, ##version 6 - Replace Found Set]

Sort [Restore, no dialog]

Go To Layout [Your report layout]

For this script you will want to do a manual sort first, that matches your report layout (for your summary parts)

HTH and that we are somewhere close.