I'm trying to connect a new crystal report to a query in my database. I get an error when I try to add the query to the new report:

Error opening file
There are no fields in the file "qry:TotalTime"

I'm using MS Access 97 with the ado connection and OLEDB in the connection string. I have fields in this query from 2 tables in the same database, so I'm not sure why I get this error. Can anyone help?

Thanks aja