Export to excel

[Brianfree]

Hi i am having problems creating an excel file from access with critera...


The file is created ok but none of the filters are present all records are in the file..

This is my crit...

crit = strWhere


This is my command which works ok...

DoCmd.OutputTo acOutputQuery, "Autoroute", acFormatXLS, , True

How can i get it to export to excel with the filters?

Kindest regards,

Brian

 

[randy700]

I think you need to build your where clause into the query.


Randy

 

[Brianfree]

thanks for the reply, have you an example on how to do this???

many thanks

brian

 

[randy700]

SELECT * FROM [i]YourTable[/i] WHERE [i]criteria[/i]

Randy