query question!

[Guest]

I have a query that includes a criteria of entering begining date and ending
date. I would like behind the scenes to have those results in an excel
spreadsheet instead of running the query and copying and pasting into the
spreadsheet!

Any ideas would be greatly appreaciated!

 

[Jeff Boyce]

You don't have to copy/paste to the spreadsheet. You can export the query
(File | Export with the query highlighted). If you're using parameters for
the criteria, exporting the query to a spreadsheet will cause the prompts to
happen.

Regards

Jeff Boyce
Microsoft Office/Access MVP