formula range issue

[smeyer56]

I am using CR 8.5 to pull data from SQL Server 2000
I have a formula that partially works.

stringVar start := toText({?StartZip},0);
stringVar end := toText({?EndZip},0);

IIF ({?StartZip}>0,{tblInquirers.FldInqZip} in start to end, {tblInquirers.FldInqZip} in toText(0) to ToText(99999))

if I enter a broad range(ie 10000 to 11000) the report works fine but if I try a smaller range(ie 11000 to 10900) the report shows no data even though I have data in this range.

Any ideas?

 

[kskid]

In your example of the smaller range, you would get nothing because the start range is greater than the end range.