Macro in Access

[billykiller05]

I am new to access and I would like to write a macro to run a query. I receive a file each month so I need to be able to change the table for which the query is ran. I need some help getting started.

 

[rconverse]

That works great. Thanks again. Is there a way to add the date I use to run my query to the filename each time so the spreadsheet would be TopAccounts 05-2008.xls or TopAccounts 04-2008 depending on the date used?

If you have this in code, you can:

...,"TopAccounts " & Format(Date(), "MM-YYYY") & ".xls",...

I am not sure if the same functoinality is available setting up as a through a macro, but you can try.

Does this actually open your queries to view (the openqurey command in your macro)? Because I want to create a series of macros to just run, I don't need to see them as they are make table and update queries.

Thanks,
Roger

Edit: Nevermind my question, I figured it out.