Filtering Records on Data Report
i want to make a report where i can filter a record by date and by county
but i cant do it at the same time well i can filter it by county itself or by date itself here's my code:
for county:
DataEnvironment1.rsCommand1.Filter = "County ='" & Combo1.Text & "'"
for date
DataEnvironment1.rsCommand1.Filter = "DP = '" & Text1.Text & "'"
for both but causes a TYPE MISMATCH ERROR
DataEnvironment1.rsCommand1.Filter = "DP = '" & Text1.Text & "'" And "County ='" & Combo1.Text & "'"
Can you help me?