Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reports for newbies
Strategies
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.
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.