Results 1 to 3 of 3
  1. #1
    michaelxhermes is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    6

    Very simple Access query and / or group report - Access 2013

    Very simple Access query and / or group report - Access 2013



    I have 2 tables, customers and holidays.
    The holidays table can have many records for the same customer (one for each holiday)
    How to I select just the customers that have more than one holiday and report on these customers only.

    I am stuck with what is the best and simplest method to do this

    Please have a look at my database here ,

    Thanks very much for your time

    Michael





  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In addition to customer table, and holiday table,
    you need a tCustHoliday table to store the holidays per customer...
    custID, Holiday

  3. #3
    saudkazia is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Location
    India
    Posts
    71
    You need to create a query and link custid with id from both tables

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

Similar Threads

  1. Replies: 1
    Last Post: 08-13-2015, 05:16 PM
  2. Passing values to a report from a form in Access 2013
    By InspectorHound in forum Reports
    Replies: 1
    Last Post: 06-17-2015, 02:58 PM
  3. Replies: 2
    Last Post: 03-10-2015, 04:22 AM
  4. Images in Report Wizard Access 2013
    By quenton in forum Reports
    Replies: 1
    Last Post: 11-05-2013, 04:23 AM
  5. Simple Group By Query w a placeholder record?
    By murfeezlaw in forum Queries
    Replies: 2
    Last Post: 11-24-2012, 09:59 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