Results 1 to 8 of 8
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    What is faster? Calculated field within table or query with added column?

    Hi Guys,



    what is faster? Calculated field within table (sum 2 of columns for example) or created new column using query?

    What do you think?

    Does it matter at all?

    Jacek

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    never put calculated fields in a table
    always calculate in a query

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    thank you ranman256.

    Can you also explain why is this?

    Best,
    Jacek

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    query calculation are always live.
    vs table : A field my not get updated then the value is wrong.

  5. #5
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Hmmm thank you!

    Jacek

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Other considerations:
    no other database engine (DBE) allows or supports Look up FIELDS in tables.
    Look up FIELDS hide what is truly going on. See http://access.mvps.org/access/lookupfields.htm

  7. #7
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    hi ssanfu,

    thank you.
    I was asking about calculated fields, no look up fields.

    Best,
    Jacek

  8. #8
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664


    Head was in a different thread. Sorry...


    Should always stay away from DLookup fields in tables, CALCULATED fields in tables and multi-values fields.

    See Calculated Fields by Allen Browne

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

Similar Threads

  1. Replies: 9
    Last Post: 01-14-2018, 07:17 PM
  2. Calculated Column in a Table
    By asmith533 in forum Programming
    Replies: 1
    Last Post: 02-10-2015, 07:53 AM
  3. Replies: 3
    Last Post: 02-13-2013, 10:15 AM
  4. added text to entire column in the Query
    By Jerseynjphillypa in forum Queries
    Replies: 3
    Last Post: 06-12-2012, 09:39 AM
  5. Replies: 0
    Last Post: 12-03-2010, 02:17 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