Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Subsummary procedure



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__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.