Hi Guys,

I know i need to learn more on the SQL front, but for now, instead of building 500 different queries, how can i code straight into VBA.

At The Moment, I use this on a button
    DoCmd.OutputTo acOutputQuery, "CIMSWrittenMTDQ", acFormatXLS, "C:\DB\Reports\CIMS All Written Sales MTD.xls", True, "", , acExportQualityScreen

Which leads to the "CIMSWrittenMTDQ" Query. This query uses 2 Criteria:

Type (Today, Month to Date, Year To Date)
Advisor

============================

I'd like two combo boxes for the Criteria. Lets Say
Combo_Type
Combo_Advisor

And then a button which will run the above DoCmd.Output using the SQL code and apply the combos to the SQL code. Sample SQL Code Below

============================

SELECT SalesALLQ.NetWrittenAMT, SalesALLQ.GrossWrittenDate, SalesALLQ.Status, SalesALLQ.NetIssuedAMT, SalesALLQ.AdvisorID, SalesALLQ.FullFirstName, SalesALLQ.Brand, SalesALLQ.WIPID, SalesALLQ.ClientFullName

FROM SalesALLQ

WHERE (((SalesALLQ.GrossWrittenDate)>=DateSerial(Year(Date()),1,1)) AND ((SalesALLQ.Status)<>"Pre 2021 Clawback") AND ((SalesALLQ.AdvisorID)=7));



As Always, a huge thank you for your time