INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Strategies

Reports for newbies by solun
Posted: 13 Apr 05

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.




Back to Microsoft: Access Reports FAQ Index
Back to Microsoft: Access Reports Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close