No that did not work either. I also tried !empty. It keeps on returning:

Function name is missing )

I do not know if that is because the account number field is a character or not. But it does not come up...any other suggestions? I attempted to add quotes around the fields but it blew a syntax error.



>It is nothing to do with the 'method': I suppose that account source field is empty. Audit the source table or add the condition for scan:
>
>scan for numeric_source_field>0
>.....
>
>>The problem that I seem to have with this method is that it does not catch the end of file and leaves it open - so the last part of the string is set filter to .... account_no<>777 and account_no <>
>>
>>>Something like this:
>>>
>>>lccom="set filter to between(date, ldstart, ldend)"
>>>sele (filter_source)
>>>scan
>>>lccom=lccom+" and account # "+alltr(str(numeric_source_field))
>>>endscan
>>>
>>>sele (table_Where_filter_should_be_set)
>>>&lccom
>>>
>>>
>>>>In regards to multiple filters...I have a table that can be added to (it only contains one field), and it needs to be used as the source for filtering. This table contains account numbers.
>>>>
>>>>How can I manipulate Foxpro into using the conditions of that table? For example...manually I code as:
>>>>
>>>>set filter to between(date, ldstart, ldend) and account <> 100 ;
>>>>and account <> 150 and account <> 500 and account <> 100600
>>>>
>>>>You get the picture. Any suggestions on how i can get around this? Thanks!