Results 1 to 2 of 2
  1. #1
    SimplyBrass is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    1

    Are you coming / RSPV / members

    Afternoon,



    i am returning to access after many years of not using it so please bare with me if some of my answers sound a little stupid.

    Scenario - I am currently in the process of redesigning the publicity for a brass band i play in in Scarborough UK. all members think it would be a good idea to have some way of them all being able to commit to our concerts throughout the year. i'm not looking for anything fancy for now but the initial steps are driving me crazy.

    I have:

    Table one: contains all information about band members, Names, address, telephone numbers ect.
    Table two: contains Concert information Venue, Time, Date, information

    i need some way of connecting these together for members to be able to say weather or not they are able to attend each of the concerts.

    list of names - can you go, YES/NO, simply job done.

    can this be done on MS access and how?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Perhaps 3 tables. You may have more fields depending on your needs.

    Click image for larger version. 

Name:	BrassBandPeopleAndEvents.png 
Views:	14 
Size:	11.4 KB 
ID:	33149

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

Similar Threads

  1. display only active members in report
    By white2golf in forum Reports
    Replies: 3
    Last Post: 01-26-2016, 04:50 PM
  2. search and edit members
    By Mohammadsharif in forum Access
    Replies: 3
    Last Post: 04-08-2015, 07:36 AM
  3. All family members with one address
    By Grams in forum Access
    Replies: 5
    Last Post: 08-25-2014, 05:51 PM
  4. Replies: 24
    Last Post: 02-04-2014, 07:26 PM

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