Another question i have is how to display back a selection of information. I want to write a script that will let me view results that only lie between __ and __ what would this script look like?

Enter Find Mode []

Insert Calculated Result [DateToText (DateStart) & "..." & DateToText (DateEnd)]

Perform Find []

For example.

What i mean by between __ and __ is, say you have a bunch of files, ranging from 0 to 1000, what is a script that would allow me to only find data between 100 and a 1000.

You will need to have a Record ID number. And then you could search (Find) >100 in the field.

HTH

Lee

A reord ID, what is that? Do you mean the record number in the upper left hand corner? What I'm looking for a way to show all data in two fields between 100 and a 1000. I have a field labeled start and one labeled end, i want to review all data that fall in a start point no less than 100 and end point no more than l000. So how would this be done. By the way, thank you for your help it is most appreciated, both you and tfitch have been most helpful.

Repost from another thread that used dates instead of numbers, but the process is the same...

Another method you could use if you often script/perform the same find is having a set of 2 date global fields in your Main file and create a calculation field on your related file

matchdatecalc using a constant relationship = Case(d_date<=::g_end and d_date>=::g_start;1;0).

Then trigger a script in your related file that will only find for matchdatecalc = 1.

Find mode

Insert calculated result (matchdatecalc,1)

Perform Find.

Of course, this method also works on the file itself, with no relationship at all.

Just replace dates by number in your case and set a second calc for the second field.

Then finally add a Modify line for your Find

Find mode

Insert calculated result (matchdatecalcN

Sorry, I should have figured that you would need this information.

Make sure that the records are Unsorted by going to the Sort Menu and if the option "Unsort" is available, click it, otherwise cancel out.

Now, go to a layout where you want to put this field. Next, create a new *number* field, and Call it Record ID. Next go into Options for that field and select Auto Enter - Serial Number (it defaults to 1 and increments of 1) so just click Okay and then Done.

Now go to the field in Browse Mode and click cursor inside of it. Now go to the Menu, select Records, and then Replace (Cmd = on a Mac). In the Replace menu, Select the second button about serial numbers, and then click okay.

You now have a number for each record.

HTH

Lee

Lee, you're answering a different question.

"I have a field labeled start and one labeled end, i want to review all data that fall in a start point no less than 100 and end point no more than l000."

Enter Find Mode []

Insert Text [start, ">=100"]

Insert Text [end, "<=1000"]

Perform Find []

what exactly does the record id represent, is it the record # in the left hand corner, becasue i need to query off of a certian field. And thanks for your help on this and my other issue, i appreciate it!

sorry about that lst post, i thought my other one didn't enter in yesterday.

Hi yono and Tom,

As you can see by Tom's posts, he and I are not in agreement of what you are wanting.

It was my impression that you were trying to isolate some records and was referring to the numbers under the rolodex seen in the upper Left-hand corner of the layout. If so, these number are only a reference to the record in view as it relates to the group of records in your current found set. Other than this, it is useless to you, as you can not do a find based on the numbers you see.

If that wasn't what you were referring to, than please accept my apology for adding to any confusion in this matter. If it was, then you need to find a different commonality between the records that you are wishing to isolate. My suggestion was based on the fact that you were trying to isolate record Number 100 through 1000. In order to do that, you would need to create a Record ID number and populate it, which was what I was trying to explain in my earlier post.

Otherwise, you need to do a find in a field base on something they have in common.

HTH

Lee