What is the length of the final lccom expression? Cannot remember exactly, but filter expression is limited in length.
And what is the account field type, numeric or character? If it is character type, then your 'manual' and initial example wil not work either.

>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!