Okay, I have a database in access. I run a query and after running the query it updates the query and places it in excel in a pivot table. I put in a command to print the pivot table and it prints, but it prints the previous quer, but shows the new query on the pivot table.

What am I doing wrong that I can't print the table. I can hit the print icon, but I'm trying to make it user friendly and press one button to run the query and print the form.

Help