Results 1 to 3 of 3
  1. #1
    mahmud1180 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Posts
    20

    Difference between the value from two different date


    Hey, I have two select queries joined by a union query. But I need to make some adjustments to the latter query. The adjustment is the difference of the last value of the first query and the first value of last query. Any help from you? Thanks in advance!!!!!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Dont think you can do that in a union. Neither query can see the other.
    THO, you might be able to a MAX, MIN as a field in each

    You'd have to get those values AFTER the queries resolve in a form function with MAX or MIN.

  3. #3
    mahmud1180 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Posts
    20
    oh I see.. min and max function on the ID number I guess... Thanks for your reply.

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

Similar Threads

  1. Date Difference Not Quite Right
    By StevenCV in forum Access
    Replies: 11
    Last Post: 01-30-2014, 08:12 AM
  2. Date difference
    By Kaaivin in forum Queries
    Replies: 2
    Last Post: 07-03-2013, 06:06 AM
  3. Date Difference from same column
    By akmehsanulhaque in forum Queries
    Replies: 1
    Last Post: 02-19-2013, 01:31 PM
  4. Replies: 1
    Last Post: 02-12-2013, 03:48 AM
  5. Replies: 2
    Last Post: 01-23-2013, 11:07 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