Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    One-to-Many Relationship (2003)

    I have several tables I need to join, or some how make a relationship with to make a query and ultimately a report. I'm not sure what to do. I am a realtively new user. I put the cart before the horse and created a form that I thought I could use as my printout but I can't get it to page break before each new record. Can I somehow convert this to a report to print it out?

    Any suggestions would be welcome.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: One-to-Many Relationship (2003)

    Monica,

    I would start by creating a query with the information that you want on the report. In order to join all the tables, you need to identify what information in each table can join the two tables together. Once you get that done, you can use the Report Wizard to create a report -- you can play around with the variations.

    If you like the form, you can simply highlight it and on the Menubar, chose "File->SaveAs," and chose, "Report."

    However, I wouldn't recommend that until you successfully get the data that you want to display, successfully tied together.

    There are a lot of local businesses offering 1-day classes for beginner, intermediate & advanced users, and I would strongly recommend that. Not only are you doing yourself a favor, you are doing the economy a favor, if you or your business can afford it.

    thx
    Pat

  4. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,325
    Thanks
    1
    Thanked 12 Times in 12 Posts

    Re: One-to-Many Relationship (2003)

    Just as an add-on the what Pat suggest about training, you should also check local colleges and junior colleges. They often have special training classes that require less time commitment than a full course (although that isn't a bad idea). Often they will have something like a Business Development Center that offers such classes (maybe on a weekend) primarily aimed at business people.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •