Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    38

    Unanswered: Display a single record in a query

    Hi,

    I have a query that finds all the records in the 'projects' table equal to a date.

    The 'projects' table has a related table called 'engineering notes'.

    Is it possible to have the query display the last engineering note for each project that meets the criteria?

    For example, when I run the query to find all the projects started this month, the query returns the same record for each engineering note and then carries on to the next project. All I want is a list of the projects plus the last engineering note so I can see at a glance the projects started and the latest engineering note for that project.

    Thanks

    Nigel

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    What you're trying to do is group by and show last, which are "Totals" functions.

    Use the big Greek E at the top of the query builder to expose those commands and then group on projects, setting it to display the Last note.

    Depending on how your db is setup, you'll probably want to do the "Totals" query simply on Project Key and Note key, and then use a select query to fill in the meat.
    have fun!

    Todd S.
    click to email


    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET


    _________________________________________________
    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  3. #3
    Join Date
    Jul 2009
    Posts
    38

    Smile

    Thanks tcace.

    Its working fine now, that was really easy, well it is when youre pointed in the right direction.

    Nige

Posting Permissions

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