Results 1 to 3 of 3
  1. #1
    rik05171981 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2016
    Posts
    1

    Calculation in a form not working like I need it to.

    Can some on help me! I have a drop down box that is reading from another table and has a cost and size in it . I need the user to beable to chose the size but then I need access to beable to use the cost fr the size for a formula. W/36*Cost. I attached the database so you can see what I'm looking at. DPT1-DESKTOP-FI00T64.zip

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    then your drop box only should only show Size,
    then another drop box show Cost for THAT size picked.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I would suggest you stop and rethink your dB structure. I see many things that should be corrected; you will probably have lots of headaches if you don't.


    1) Object names should be only letters and numbers. NO spaces, punctuation of special characters. You have spaces, the hash mark (#) and a slash (/) in object names. Also, not begin an object name with a number.

    2) Having "ID" as the PK field name for every table is a very poor name choice.

    3) You have repeating fields in your tables. Repeating fields are fields like "Width", "Width2", "RollSize", "RollSize2", etc (like the fields in table "Accord"). It indicates the table structure has flaws.

    4) You have look up FIELDS in tables. I NEVER use look up FIELDS.
    See http://access.mvps.org/access/lookupfields.htm and also http://access.mvps.org/access/tencommandments.htm

    5) "Width" is a reserved word in Access and shouldn't be used an object name.

    6) I didn't see a FK field to the "Customers" in any table.

    7) I would expect at least one date field in the dB.

    8) I would not use a calculated field type. In a properly designed dB, most of the calculations would be done in a query.




    Maybe you could describe your business. We would have a better idea of what you are trying to do.

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

Similar Threads

  1. Replies: 13
    Last Post: 01-22-2015, 05:27 PM
  2. Calculation not working on report
    By CS_10 in forum Reports
    Replies: 6
    Last Post: 04-08-2014, 09:10 AM
  3. Calculation Field in table vs Query calculation
    By Leonidsg in forum Database Design
    Replies: 18
    Last Post: 02-28-2013, 09:38 PM
  4. BMI calculation formula not working...
    By coolpal9 in forum Forms
    Replies: 2
    Last Post: 03-27-2012, 12:06 PM
  5. Total Calculation, nz function, not working
    By Jojojo in forum Programming
    Replies: 3
    Last Post: 10-10-2011, 02:33 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