Results 1 to 10 of 10
  1. #1
    matteozz is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2015
    Posts
    9

    Problem in crossing datas and tables. This problem looks like the battleship game


    Hello everyone,

    unfortunately I have several problems in carrying out a job, so I have many doubts before to present everything clearly.

    I have a value that comes from some of the formulas set out above, let's call WEIGHT. Then I have another value, the CAP.

    WEIGHT must be associated with the weight ranges: up to 100, 300, 500, 1000, 2000, 2500, 3000, 4000, 5000.

    The CAP will instead be assigned to a particular area: ZONE 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11. In the same area can be assigned more CAP.

    The end of the weight determines a cost in relation to the area.
    Suppose that the 300 is up to 300 and the ZONE 7 (because for example the cap 41 corresponds to that area), in this case you will find a value that should be determined previously, we have made 10; if the range is 1000 and the ZONE 1, the value found will be different. A little 'as the baleship game!

    I am confused about how to create tables with data and to ensure that they relate properly and with all parameters!

    Thank you all for the tremendous help

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,834
    tZone table

    ZONE , CAP
    1, 500
    2, 300
    3, 2000

    but still not sure what youre doing with Weight.

    tWeightReadings:
    zone, weight
    1, 200
    1, 250
    1, 300

    is this it?

  3. #3
    matteozz is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2015
    Posts
    9
    It's very simple... take a look to this scheme
    Having the WEIGHT and the CAP I 'd like to determine the green highlight number (3.00 €)
    Click image for larger version. 

Name:	[Senzanome].jpg 
Views:	17 
Size:	184.8 KB 
ID:	21144

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,505
    @matteoz

    Can you clearly describe the associated business in simple English?
    What exactly do these WEIGHT, ZONE, CAP , AREA and COST represent?

    It seems to me that your confusion is based on a lack of clear definition of the issue.
    Hats off to ranman if he has guessed correctly, or understood your requirement.

  5. #5
    matteozz is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2015
    Posts
    9
    Ok, I'm sorry but I'm not a database expert and my English is really poor...
    I'll try to be the most clear I can.

    I want to determine some costs because I work for a transport company. So, the problem is that I have a data, which is the weight of the goods, for example 300 Kg.
    To determine this final cost to apply, I have to look at a table where there are some crossing datas.
    In addition to the first data (300 Kg), I have the CAP (the Italian for ZIP code).

    I also have a table where every ZIP is associated to his ZONE (It's a group of ZIPs of a geographic area) and I have some ranges of weight...
    What I want to do is to determine to which range the weight correspond (300's range), and the zone of the ZIP code. In doing this i can obtain the cost...

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,505
    Your English is quite good ---certainly sufficient for communication.
    I understand Weight (kg). But what is the unit of measure associated with CAP?

  7. #7
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,834
    In Access your data will be stored like this:
    ZONE CAP
    ZONE1 41
    ZONE1 50
    ZONE1 36
    ZONE2 74
    ZONE2 65
    ZONE3 22
    RANGE ZONE AMT
    100 ZONE1 2.00
    100 ZONE2 11.00
    300 ZONE1 3.00
    300 ZONE2 12.00

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,036
    CAP is like ZIP code - a postal identifier? This is a postal weight rate chart? Given a weight and CAP, lookup the rate? Normalized structure suggested by ranman should make this easier to accomplish. There are ways to deal with non-normalized structure but why bother if normalizing makes life easier?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,505
    I agree with ranman and June -- normalized structure ( as always with rdbms) will make life easier, and queries, calculations possible.

  10. #10
    matteozz is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2015
    Posts
    9
    Quote Originally Posted by ranman256 View Post
    In Access your data will be stored like this:
    ZONE CAP
    ZONE1 41
    ZONE1 50
    ZONE1 36
    ZONE2 74
    ZONE2 65
    ZONE3 22
    RANGE ZONE AMT
    100 ZONE1 2.00
    100 ZONE2 11.00
    300 ZONE1 3.00
    300 ZONE2 12.00
    Thank yiu for your reply!

    So, I'll create two table like you show me. In doing this, I hope to will be able to creare some realtions between theme and the obtain the final reasult. This won't be an easy work but I'm gonna try

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

Similar Threads

  1. query with 2 tables problem
    By zajkowsky in forum Access
    Replies: 1
    Last Post: 03-11-2013, 07:28 PM
  2. Problem with tables (beginner)
    By alouest in forum Access
    Replies: 5
    Last Post: 04-05-2012, 12:08 PM
  3. railroad crossing
    By zrawe16 in forum Access
    Replies: 5
    Last Post: 01-19-2012, 07:41 AM
  4. Relationship problem with Tables
    By comteck in forum Access
    Replies: 7
    Last Post: 12-28-2011, 03:45 PM
  5. Problem with linked tables
    By meijermartijn in forum Import/Export Data
    Replies: 6
    Last Post: 08-24-2011, 01:48 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