Results 1 to 2 of 2
  1. #1
    Canadiangal is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    81

    Does it Matter? Pulling fields in a query

    My question is this:
    When creating a calculated field in a query, does it matter where you pull the fields from inside of the calculation?

    Example:
    Calculated field

    Price - Cost Where both price and cost are fields in the query

    or

    Table!Price - Table!Cost Where both price and cost are fields in a table.

    Is it a better practice to always pull fields for a calculation with the fields listed in the query?

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    If the field name could come from more than one table then it is wise to bring it down so you can identify it correctly, however if it only appears once then there is no need to do so, unless you want to use it for some other reason.

    David

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

Similar Threads

  1. Pulling Record Info From Sub Form
    By redlich23 in forum Forms
    Replies: 1
    Last Post: 09-02-2009, 02:10 PM
  2. Replies: 0
    Last Post: 07-27-2009, 07:51 AM
  3. Yes/No Fields and Criteria in a Query
    By omicronkappa278 in forum Access
    Replies: 1
    Last Post: 05-22-2009, 09:51 AM
  4. Pulling out duplicates
    By FREEEEEEDOM in forum Access
    Replies: 1
    Last Post: 04-21-2009, 10:37 PM
  5. Pulling most recent data from child table
    By davidv43 in forum Access
    Replies: 0
    Last Post: 02-07-2009, 11:36 AM

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