I am trying to create a report that pulls records for which a foreign key value matches one of a handful of values that are not next to each other (like 25, 678, 1254). The underlying field is set up as an integer value. In the Foxfire data dictionary (created before my time) the corresponding field is numeric.

When I add values and attempt to run the report or generate the SQL query, I see a row of XXXXXXXX in the filter box for this item. Click within this box brings up a series of error dialog boxes as follows:

Function argument value, type, or count is invalid.

Variable 'COMMA_POS' is not found.

Function argument value, type, or count is invalid.

Variable 'ONE_VALUE' is not found. (3 times in a row)

I click ignore on each window and eventually it goes away and the filter box is available with a blank box for the item. I can now enter values.

I'm beginning to suspect that list of values may not work properly with numeric data. Any comments or suggestions would be appreciated.

Thanks,

Dale