Results 1 to 2 of 2
  1. #1
    alka is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2013
    Posts
    25

    Easy query calculus

    I have 3 column

    Column 1 from another queryA has the field ValueA


    Column 2 from another queryB has the field ValueB
    and I want my 3rd column to be: =[queryA].[ValueA]-[queryB].[ValueB]

    I tried to put that in Criteria but I'm pretty sure it is not there

  2. #2
    alka is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2013
    Posts
    25
    SOLVED: had to put the code in the field like this: Column3Value: [queryA].[ValueA]-[queryB].[ValueB]


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

Similar Threads

  1. Replies: 3
    Last Post: 09-26-2012, 01:24 PM
  2. Replies: 1
    Last Post: 05-18-2012, 11:59 AM
  3. Query, VERY EASY QUESTION, I think
    By GiSharp in forum Access
    Replies: 3
    Last Post: 09-12-2011, 05:39 AM
  4. Easy query problem
    By nparrillo in forum Queries
    Replies: 3
    Last Post: 04-05-2011, 02:28 PM
  5. Replies: 0
    Last Post: 03-29-2011, 09:37 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