Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    100

    Unanswered: Referring to query created fields within same query

    Using the query designer, here is what I'm hoping for:



    Box1: Field1.......Box2: Field2.......Result: Box1-Box2
    5...........................2..................... .........3
    6...........................2..................... .........4

    This is a very simplified version of what I'm trying to do. Neither Field1 nor Field2 are actual fields from a table or other query. They are both calculated fields.

    Whenever I try to enter the Result column it always asks me to enter Box1 and Box2 rather than knowing they are found within the same query.

    Thanks!

    Norm

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    SELECT 5 AS Box1, 6 AS Box2, [Box2]-[Box1] AS Box3;



    S-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •