Apply second filter to filtered data

[gemadan96]

I've created a split form that shows all records on a SQL Server table. On that form are several buttons to filter the data by Today, Yesterday, This Week, Last Week, etc.



I want to create buttons to further filter the data by values in another field. I have created buttons to do that but rather than applying the filter to the filtered records it applies it to the entire table.

I'm trying to make this as simple as possible for the end users as opposed to selecting the field and filtering the data that way.

Is this possible?

[lfpm062010]

This is one way. It is possible. It require VB.

You have rebuild the WHERE clause.

[gemadan96]

Can you provide an example?