I would like to run a report on a panel which selects a range of records
where the selection is done on an alphanumeric field.
The field in question contains text entries such as
Smith 1
Smith 2
Smith 3
Smith 4
and so on until
Smith 20
Smith 21
Smith 22
Smith 23
Smith 24
If I wished to select the range Smith 20 to Smith 22, using the Specify
Range in Search Options for Reports does not work (because it is a text
field).
Using a formula such as min[P1F1="Smith 20"] will produce
Smith 2
Smith 20
Smith 21
Smith 22
Smith 23
Smith 24
and I get the same result if I specify, say min[P1F1="Smith 21"].
I have read Ralph Alvy's Mastering DataPerfect, Formulas chapter on
"obtaining perfect matches and identiy operator", but hat does not
appear to make any difference.
Help with this would be much appreciated.
Victor Warner.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
