Search from to range

[Spice]

Hello All

This is a proverbial Newbie question.

My database contains 500+ articles all of which have several criteria (simple value list dropdown menus of existing records). One of these is a Year field. I know users can use the "..." to search for a range of years but this is not obvious enough. My prefered solution would be two Year fields, one marked "DateFrom" and the other "DateTo" with dropdown value lists for each. All this in Search mode of course.

If anyone could show me the right direction on this that would be great.

As a refinement it would b great if the value list "DateTo" would only display values ≥ "DateFrom" valuelist choice and, even better, the "DateFrom" valuelist would only show years ≤ "DateTo" value list choice. I assume this would be done with relationships but I cant seem to get it working in Find mode.

Thanks.

[bdonelson]

Hi,

I have the same question, and also what is

I know users can use the "..." to search for a range of years

that Spice spoke of?

[bdonelson]

I found one way to accomplish a search range, date or otherwise. Duplicate the field, that is have a second field that is a calculated value of the first field. In the script, you can then specify both criteria.

Bill

[comment]

Have you read the help on this (Contents > Finding, sorting, and replacing data > Finding records > Finding ranges of information)?

[bdonelson]

Now I haven't.

Do you mean search for the topic "Contents > Finding, sorting, and replacing data > Finding records > Finding ranges of information"?

Thanks,

Bill

[comment]

No, I meant open the Help, and from Contents navigate as indicated.