
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
I already have a solution for my problem, but there might be better ways. I may not use the correct terms, I use a German version of FMP 5.5. A file with a date field and 100 records. 12 records have an entry in that date field, like: in 5 records, it's Dec 5 in 4 records, it's Dec 7 in 3 records, it's Dec 13 The scripts must find the 5 records with the first date and run a script with this selection. Afterwards, it must find the next 4 records and do the same. After that, it must find the last 3 fields, and do the same. No need to do anything with the remaining 88 records. First problem: Find fields with data in a date field. My solution: search for empty fields an show omitted records, or search for fields with dates bigger than 1900-01-01. Better ways? * does not seem to work in a date field. Second problem: find out how many different dates are there and store them for the different find operations. My solution: I sort and then export with summaries into a text file, import that text file into another FMP file and start loops from there. Better ways? -- http://clk.ch
| <-- __Chronological__ --> | <-- __Thread__ --> |