So wait it that ControlSource for the textbox? and is the [enter start] and [enter end] supposed to be [[Forms]![Par-Pak final].[startdate]] and [[Forms]![Par-Pak final].[enddate]] ? For the form part i triend changing the Graph RowSource to
SELECT Union3T1.Act, Sum(Hrs) FROM Union3T1 WHERE [Date] BETWEEN [StartDate] AND [EndDate] GROUP BY Union3T1.Act;
with the two comboboxes (with names Start Date and End Date) in the form to be SELECT Table1.Date FROM Table1 GROUP BY Table1.Date ORDER BY Table1.Date DESC;
but that only produced an empty report