If you don't have the MySQL Connector/OBDC installed, you'll need to install it. Quote from the MySql.com site: "
MySQL Connector/ODBC (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft Access, Microsoft Excel, and Borland Delphi." That driver should provide you with a usable record set.
That said, to then link to your table and use it in a query and report, click on the menu bar
File,
Get External Data,
Link Tables.
You'll get a Link window. At the bottom of that window is a drop-down box labelled "
Files of Type" where you select
OBDC.
You will then get a "
Select Data Source" window. Select whichever tab ("
File Data Source" or "
Machine Data Source"

is appropriate for your data source (MySQL), then select the appropriate entry.
At this point, you may get an ODBC login form for that data source. Once connected, you will get a "
Link Tables" window showing all the tables available in the data source you selected. Select one or more tables as needed, then click
OK. Now you have the table linked to Access and you're ready to create your query using that linked table as the data source.
Presumably you know how to create a report... just select your query in the drop-down box labelled "
Choose the table or query where the object's data comes from" in the
New Report window.
That should pretty much take care of it.
Hopefully this gets you the results you're after.