MS Access OutputTo Report using filter string
Posted on 2010-11-15
I am trying to create an outputto report function for my database. The report currently filters propery when using
DoCmd.OpenReport "rptFilter", acViewPreview, , strWhere but I would like to be able to output this to an excel spreadsheet with the filtered items being displayed. I have tried using the DoCmd.OutputTo acOutputReport, "reportName", ... format but it doesn't filter at all.
Your help is much appreciated in advance.