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!