You may have chosen fields from record sources which the wizard can't connect

To correct this error, I simply created the query manually rather than using the wizard (wizard is not that smart sometimes). Of course make sure all your relationships are correct first.
 To create a query manually:

Create > Query Design