Results 1 to 6 of 6
  1. #1
    Abuaarah is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    3

    Calculate Values pulled from Another Table

    Hello All I am a new comer to this access as well as to this forum..! I am creating a simple database that meant for outdoor camping. and the price for camping ground is 50 per night, and participants will pay individually based on their age group apart from the camp ground.



    So when I fill the form I wanted this to be automatically calculated. and I am stuck with the calculation - If someone could help would be appreciated

    Thanks

    please check the file in this http://lancanint.com/DOWNLOADS/Database141.accdb

    I have attached the file - Thanks again

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,212
    Can't look at the sample right now, but is this applicable?

    http://baldyweb.com/Autofill.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,069
    It is safer for us here if you Save As your db (older versions are better), compact/repair the copy then zip and include in your post. You will probably get more responses that way.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,731
    Welcome to the forum...


    I think you need to step back as think about your dB design.
    Here is a link to info on Database Planning and Design. I recommend the tutorials from RogersAccessLibrary mentioned in the link. Work through 1 or 2 (30-60 minutes) and you will learn about database design.


    The way your tables are designed right now will cause multiple records to be created for one party. For example, lets say a group arrives that contains 2 parents, 4 children under 19 and 2 kids that are 20 and 21. That means with the current design, you will need to make 8 records that cannot currently be linked together.

    You will need more fields the table "ParticipantDetails" or an additional table.
    You will probably need to write your own function (a UDF) to get and store the total amount.

    Why the field for number of days? I thought you charged by the number of nights? Can you stay for 4 days but only pay for 1 night?
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  5. #5
    Abuaarah is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    3

    Thanks for your reply

    Quote Originally Posted by ssanfu View Post
    Welcome to the forum...


    I think you need to step back as think about your dB design.
    Here is a link to info on Database Planning and Design. I recommend the tutorials from RogersAccessLibrary mentioned in the link. Work through 1 or 2 (30-60 minutes) and you will learn about database design.


    The way your tables are designed right now will cause multiple records to be created for one party. For example, lets say a group arrives that contains 2 parents, 4 children under 19 and 2 kids that are 20 and 21. That means with the current design, you will need to make 8 records that cannot currently be linked together.

    You will need more fields the table "ParticipantDetails" or an additional table.
    You will probably need to write your own function (a UDF) to get and store the total amount.

    Why the field for number of days? I thought you charged by the number of nights? Can you stay for 4 days but only pay for 1 night?
    Thanks for your reply and I will check the links and see how to put together

  6. #6
    Abuaarah is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    3
    Thanks I will check this link

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

Similar Threads

  1. Replies: 2
    Last Post: 09-22-2016, 06:15 AM
  2. Replies: 15
    Last Post: 09-01-2015, 12:20 PM
  3. Replies: 5
    Last Post: 11-13-2014, 01:40 PM
  4. Replies: 1
    Last Post: 06-28-2013, 12:54 PM
  5. VB to calculate count of distinct values
    By gokul1242 in forum Programming
    Replies: 1
    Last Post: 10-03-2012, 01:38 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 - Senior Forums