Results 1 to 2 of 2
  1. 11-30-2014, 08:15 AM #1
    krjoshi
    krjoshi is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Nov 2014
    Posts
    13

    Question Help needed to create Query to add some calculated field

    Hi Folks,



    Please help me to create a Query to add some calculated fields since I am very new to Access Query.

    I have attached the Database and picture of what I am trying to accomplish.

    Thanks in advance,

    Joshi
    Attached Thumbnails Attached Thumbnails Query.jpg  
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 11-30-2014, 12:31 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Saving calculated aggregate data is usually a bad idea. Calculate the data when needed.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Workaround needed for adding calculated fields in a query
    By Abacus1234 in forum Queries
    Replies: 5
    Last Post: 09-14-2014, 02:34 PM
  2. Data type mismatch in criteria expression when using query to create a join with a calculated field
    By katrinka in forum Access
    Replies: 1
    Last Post: 07-24-2014, 08:35 PM
  3. create a calculated field in a query but not have it shown? i.e.-create a variable?
    By crobaseball in forum Queries
    Replies: 5
    Last Post: 04-04-2014, 03:33 PM
  4. Access 2013 Expression Builder is not invoked to create table calculated field
    By Philcn001 in forum Access
    Replies: 1
    Last Post: 05-09-2013, 07:54 PM
  5. Create a query With a Calculated Field
    By Content1 in forum Queries
    Replies: 2
    Last Post: 01-05-2013, 12:46 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums