SELECT [PROS Cases].CHARGES, [PROS Cases].[DATE FILED], [PROS Cases].STATION, [PROS Cases].[SPECIAL APPROVAL], [PROS Cases].[OPERATION NAME], [PROS Cases].[CRIM HIST 1], [PROS Cases].[CRIM HIST 2], [PROS Cases].[CRIM HIST 3], [PROS Cases].[CRIM HIST 4], [PROS Cases].[Convicted Sex Offender], [PROS Cases].Juvenile, [PROS Cases].Status, [PROS Cases].DISTRICT, [PROS Cases].[A NUMBER], [PROS Cases]![CONTROL NAME] & "-" & [PROS Cases]![MAMA LAST] & ", " & [PROS Cases]![GIVEN NAME] AS Name, [PROS Cases].[Gang Affiliated], [PROS Cases].[1324 Type], [PROS Cases].[Southern Hold 2]
FROM [PROS Cases]
WHERE ((([PROS Cases].[DATE FILED]) Between [forms]![pros menu]![Start Date] And [forms]![Pros Menu]![End Date]));
Here is the SQL I use the wizards a lot, so this is set up with a command button from the opening menu.