Once you have created your button, create an "on click" procedure. (I don't recommend using the wizard for this...my opinion is that it is easier to create a button with out the wizard when you are going to create your own event for it.)
For the code, you'll use the following line of code:
Docmd.OpenReport "Report Name", view preferred, filter, condition, window mode, open arguments
The "Docmd.OpenReport" you will type in. The view, filter, condition, window mode, & opening arguments are all items that you chose depending on exactly how you want the report to open.
I hope this helps.
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!