The report writing wizard is pretty good but only if you've got a query that shows all the data you want to use for the report.
For example, I have a database containing tables of pets, vets, and owners
The Pets table has these fields: Name Type Breed Birthyear Color VetID (1-to-many relationship with a table of vets & addresses) OwnerID (1-to-many relationship with a table of owners and addresses)
What if I want a report that shows the owners & names of dogs that go to a certain vet?
I would create a query (qryDogsMansfieldVet) that includes all three tables and that shows the details of pets where a. dogs (Type = "Dog") b. vet (VetID = (id of the Mansfield Vet))
When I got thru the report writing wizard, I can specify that the report should use qryDogsMansfieldVet as its record source. Poof! You have a nice little report that didn't cause you to pull out your hair.