In my opinion a reasonable question was asked. "how can i add a button on ms access report to export it to excel / pdf any help appreciated." Not the most elegant question but certanily enough for me to give several links to VBA code with answers. Which I did in the comments. Now there are non VBA means of getting Excel and PDF reports but I've used VBA lots for this before which has a number of advantages.
However, Jeff Atwood closed How can I add a button to an Access report to export it to Excel / PDF? stating "closed as not programming related"
Which of course I disagree with.
So now what?
How do I send Jeff an email?