I have a report based on the following saved Query:
SELECT Crime_Table.Offense, Count(*) AS [Number of Crimes]
FROM Crime_Table
GROUP BY Crime_Table.Offense;
What I want to do is be able to pass in a where clause that is generated from a form.
Is this possible? Would I need to change the recordsource dynamically? if so how do I do this?
Any help would be greatly appreciated.