Page 3 of 3 FirstFirst 123
Results 31 to 32 of 32
  1. #31
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,389

    Sorry, the established law of physics says W=I*E. So if you say that power = W * I * E, the power is squared.
    The first formula is strictly for DC circuits. For AC, a Power Factor can come into account to increase the power consumed somewhat, but certainly not to square it.
    Perhaps the UF and DF are factors to adjust for the bloat.

    In any case, the DB in post#26 eliminates the multiplications by zero problem.
    Last edited by davegri; 07-22-2020 at 09:38 PM. Reason: sp

  2. #32
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,870
    I would suggest you pause and get your table designs fixed. (as mike60smart said in Post #20)
    To me, it looks like the table "Client" could be split into at least 3 tables:
    1) Client info,
    2) Survey info and
    3) Study info
    but I am not totally sure I know what "Client" data is.

    Also, I would suggest removing ALL spaces in the object names and the punctuation/special characters in names.

    Who or what is a Client?
    How are Utility Companies involved?
    How is a Salesman involved?


    It was a fun puzzle to try and split the client table, but since I don't know your business, I gave up - too many questions.



    My 2 cents........
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Simple question
    By blackstatic42 in forum Access
    Replies: 4
    Last Post: 07-22-2020, 08:50 AM
  2. Replies: 10
    Last Post: 03-15-2020, 01:46 AM
  3. If and Else - very simple question
    By tygereye in forum Access
    Replies: 38
    Last Post: 04-02-2014, 06:06 AM
  4. Probably a simple solution, but driving me nutz!
    By Bribie4507 in forum Queries
    Replies: 3
    Last Post: 02-22-2013, 07:10 PM
  5. A simple question:
    By kosti in forum Queries
    Replies: 4
    Last Post: 10-12-2011, 11:46 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 - Senior Forums