pldelosrios
Programmer
I have an Access 97 database attached with an SQL Server 2000 database
In Access the query is:
SELECT * FROM Table1 WHERE Field1 like FNFilter();
the function FNFilter is:
Function FNFilter()
FNFilter = IIf(Len(trim(StFilter)) = 0, "*", StFilter)
end Function
How can i make a parametrized query ????
In Access the query is:
SELECT * FROM Table1 WHERE Field1 like FNFilter();
the function FNFilter is:
Function FNFilter()
FNFilter = IIf(Len(trim(StFilter)) = 0, "*", StFilter)
end Function
How can i make a parametrized query ????
