Results 1 to 1 of 1

Thread: Update min max date with join

Threaded View

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Posts
    2,932

    Update min max date with join

    I have 2 tables CONT and CUMU, the two table have the same field named RAPP(txt property)

    In CONT have a filed named DATA (as date short)

    In CUMU have a field DAL (FROM in english) and a field AL (TO in english)

    With a join on RAPP, i need to extract the Min and Max Date from CONT.DATA and insert Min date value in DAL and Max date value in AL

    How to with a query?

    note;
    i work with ADO, Access databse and vb6 classic
    Last edited by luca90; Mar 9th, 2013 at 06:56 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
  •  



Click Here to Expand Forum to Full Width