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!