Max Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am being driven mad by what I think should be a simple query. I have a database with one table (Work_Item), which relates to two others (A_Comments) and (B-Comments) with a 1 to many relationship. These two tables are of similar structure and both contain dates. What I want to do is produce a query which shows ALL items from the main table, and the most recent item from the both of the two other tables ie Max date, relating to each item from the main table. I can't for the life of me get this to work. I can find various bits of sample SQL to do something similar within one table, but it dosn't seem to work when there are various joins involved. CAN ANYONE HELP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another most-recent date query 0
Have both records from two queries/tables under one Query without related fields. 0
Access Daily Entry with multiple entries per field 0
Query shows no results when using 2 tables with multiple relations 3
Max & Min Dates 0
Use the Second Max Value in a Formula???? 4
Similar function needed to Excel VLOOKUP 2
Finding max value 3

Back
Top