hi Eric,
End Result:
i want the other 2 search fields to work, at moment it just gives me no results.
the setup of the data assist is on my original post. that is what it produced.
date range is a date column type, client last name is a varchar column type in database.
thanks