I have a Query and a Form based on that Query. I would like to add a button to the Form that opens the Query and filters that Query based on a field in that Query called Type. I cannot seem to get the filter macro to work properly (most likely because I have almost no clue how this works). Can someone give a suggestion on what such an expression would look like? I currently have a button which opens the Query and shows all data.
OK. I figure I am not asking the right question. I have a table of all hours worked by all employees for all clients during all months. I want to be able to pull up only those records of a selected month, or only those of a selected employee, or only those of a selected client. What is the best way to do this?
Yeah, I'm detecting a communication problem here too.
I would create a custom reporting dialog box that allows the user to choose a month, client and/or employee and when they hit the preview button a report shows the list of hours details that match the criteria they've specified in the reporting dialog box.