INNER JOINs on MS Access database in ASP

[mattygriff]

I am using the following SQL query in an ASP page to try to retrieve data from one database table in order based on a date field in another table :

SELECT results.*, fixtures.fixdate FROM fixtures INNER JOIN results ON fixtures.fixID = results.fixID ORDER BY fixtures.fixdate

but I keep getting a syntax error message when I try to render the page. I generated the query from within MS Access so all the table and field names are correct.

Can anyone help ?