Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Unhappy Query Assistance Needed

    I am not familiar with Access but felt it was the best thing to use to create some reports for my company. My questions is how can I create a report that will group the following: Name, Job Title, Location, Hire Date, Years of Service...and then actually list each of the following if an employee has more than one: School, Degree, Area of study.

    What is happening is that I get a record for each person that has more than one degree because they have two records in the education table.

    Any assistance would be greatly appreciated.

  2. #2
    Join Date
    Mar 2009
    Use subreport is a good idea.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query help needed asap!!
    By msaccess09 in forum Queries
    Replies: 1
    Last Post: 02-25-2009, 09:39 PM
  2. Noob Query Help Needed
    By fenster89411 in forum Queries
    Replies: 0
    Last Post: 01-11-2009, 09:47 AM
  3. Replies: 0
    Last Post: 01-01-2007, 02:26 PM
  4. Normalization Assistance for Tables Please??
    By webmaniac in forum Database Design
    Replies: 10
    Last Post: 09-02-2006, 05:56 AM
  5. In need of assistance-products mated to mobile#'s
    By EisBlade in forum Database Design
    Replies: 0
    Last Post: 04-06-2006, 07:27 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums