Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query problem (Access2000)

    Hi guys,
    What Im trying to do is display the records. I have original records and amended version of the original record. I ONLY want to display the amended record If it exist (I dont want to display the original record when there is an amended version of that record exist). Can anyone tell me how I could do this? PLEASE........

    Right now Im using a select query to do this.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: Query problem (Access2000)

    Hello there
    We need a ittle more information pls.
    what tables do you have ?

    Which fieldNames are unique in the relevent tables ?

    Cheers
    Geof

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query problem (Access2000)

    Well there are 2 tables, one for original and one for amendments. I can pick the amendment record fine but I don't know how to pick up the recent record when there is an amendment to the amended record which will be stored in the same table (Amendment table). For more details, see the thread called Mail-Merge problem.

    The unique ID these records share are "tnum", If tnum is equal for both the records then I want to display the most recent one which could be found out by using "Create" which contains the date and time of when it was created but I don't know how.


    Thanx.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query problem (Access2000)

    if there is a date field then you could use a max of date in the query

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query problem (Access2000)

    It works jerry.
    Charlotte told me what to do.
    If you want to find out how go to
    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=77039&page=0&vie w=&sb=&o=&fpart=1&vc=1>http://www.wopr.com/cgi-bin/w3t/showflat.p...part=1&vc=1</A>

    Thanks...

    Edited to activate link--Charlotte

Posting Permissions

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