how to find sometings at two field

[fage]

Hi:friends

which script can find sometings at two fields?

i want to find "date" and "total_money".

thanks

test.zip

Edited March 2, 2006 by Guest

[Genx]

Could you please expand on your question?

[fage]

hi Genx

i have upload the file you can see it.

fage

[Genx]

... Apparently it's not a filemaker file. Try zipping it again and re-uploading.

~Genx

[fage]

sorry that file

i have upload it again to here

test1.zip

[Genx]

Um, okay im not exactly understanding your question though i had a look at your file. I assume you want to search over two fields at the same time i.e. specify two criteria, this would just involve you adding each of the criteria.

In scripting you would structure your script as follows:

Enter Find Mode []

Set Field [field name ; "criteria"]

Set Field [field 2 name ; "criteria 2"]

Perfrom Find []

If this is not what you wanted, please try and be more specific with your question.

~Genx

[Raybaudi]

Hi

try the attachment

testRevision1.zip

[fage]

many thanks!!

can i use the ≥ or ≤ to list money ?

fage

[Genx]

The short answer is yes, just make it a manual entry field instead of a pop-up menu. You can also use any other search specific characters as filemaker specifies...

~Genx

[fage]

thanks! let me test it