summarizing unique values across time span-part 2
I have posted this issue before and after much research and anguish attempting it...I believe that the ideas that I got from our Dell guy (not on Filemaker) involved scripting using If, Elseif, and Loop. I just can't for the life of me get the script to set up without fussing and fussing about the endif. Have never done this type of scripting before. My first post was on 04/21... 'I need to categorize 5000+ records into "new" or "returning" and then break them down by "length in program"... e.g. 1-2 years, 2-3 years, 3-4 years, and 4+ years. If I set up what he suggested as if statements and lay the results into count fields, I get negative numbers. Nothing has ever perplexed me for this long. HELP!!!!!!!!!!!! And, thank you all in advance.
There's a lot more we need to know about your database.
All your data is in one table?
What data in the table determines which record belongs to a given category?(New, returning, 1-2 years, 2-3 year, etc.)
This sounds made to order for a summary report and may not require the complex script you describe.