Here is the query:
PARAMETERS date_start Text ( 255 ), date_end Text ( 255 );
SELECT DISTINCTROW Count(*) AS [SOE Count], SOE.SOE, Proposal_all.Subm_date, CDate([date_start]) AS start_date, CDate([date_end]) AS end_date
FROM SOE INNER JOIN (Proposal_all INNER JOIN prop_soe ON...