Hi all, before I start I want to say I've searched through the forums for an answer but I must be using the wrong search criteria as I can't find what I'm after.
So, my problem is I have a set of data which my end users want to view and then apply several filter variations to. There is 4 filter options users want which are Work Catergory, Client, Date Range, Profit/Loss %. Any combination of these filters could be used i.e. someone may want to see all clients for a particular work catergory, profit/loss of jobs for a work category, profit/loss for a client, jobs undertaken in a work catergory in a certain date range, etc, etc. Similarly they may just want to view data for one of the filter options i.e. just all projects for a certain client.
I know a user can right click in a field and select 'data equals' which filters to just those records and they can then right click in another field and select 'data equals' to filter down further the records but is there a way to replicate this through vba or the query criteria so that the end users enter into a 4 fields one for each criteria) the data they want to filter by and simply hit a button.
Hopefully my question makes sense.
Thanks
So, my problem is I have a set of data which my end users want to view and then apply several filter variations to. There is 4 filter options users want which are Work Catergory, Client, Date Range, Profit/Loss %. Any combination of these filters could be used i.e. someone may want to see all clients for a particular work catergory, profit/loss of jobs for a work category, profit/loss for a client, jobs undertaken in a work catergory in a certain date range, etc, etc. Similarly they may just want to view data for one of the filter options i.e. just all projects for a certain client.
I know a user can right click in a field and select 'data equals' which filters to just those records and they can then right click in another field and select 'data equals' to filter down further the records but is there a way to replicate this through vba or the query criteria so that the end users enter into a 4 fields one for each criteria) the data they want to filter by and simply hit a button.
Hopefully my question makes sense.
Thanks
