can anyone help me write a stored procedure or passthrough query for the following

INSERT INTO ProcessorPaymentReportx ( MaxOfprocessorName, batchAmount, processorid )
SELECT Max(processors.processorName) AS MaxOfprocessorName, Sum(transactions.TransactionAmount) AS batchAmount,
FROM processors, transactions
WHERE ((( AND ((transactions.transactionType_id)=4) AND ((transactions.ProcessedOn) Between '9/1/2009' And '9/1/2010'))

those two dates I hardcoded to see the statement actually work from within studio mgr.
but I need to pass a parameter for them

but if it is a stored proc then I need to pass in the vaiables -
I would rather use a passthrough but i am having difficulty with all the syntax (querydef.sql etc)

I need this done by morning and I am just too fatigued to get it!
Got a new spec on friday evening and the report has to use a passthrough or sproc no recordset anything? and I am so used to dao and ado

thank you so much