Controlling reports by date
I've developed a music publishing program on FMP 10. I'm now working on the royalties and am having some real problems. Royalties are paid simi annually, I fill out the form, it divides the monies between the writers and then I print the royalties. However, if, for example, I do royalties from 1/1/2010 thru 6/30/2010 then at the end of the year I do royalties from 7/1/2010 thru 12/31/2010 it puts the royalties from 1/1/2010 thru 6/30/2010 and the royalties from 7/1/2010 together instead of separating them. (I hope you understood that.) Can you tell me how to do a script that will print by whatever date I enter instead of them all listing together?