Filter statement for filtering multiple fields

[[email protected]]

Hi

I can't figure out whats the correct syntax for filtering on multiple fields.

for 1 field i use :
dmCrew.Contact.Filter:='Status='+QuotedStr('Active');

for 2 fields i tried:
dmCrew.Contact.Filter:='Status='+QuotedStr('Active')+' AND '+'LastName='+QuotedStr('Mierlo');

[ViktorV]

Yes, you can use this code to solve the defined task.