Hello All,
I have two tables that I am trying to join in MS Access and sort by a date and only return the most current date.
Table1
JobNO Date Comment
1 4/2/03 yes
1 4/3/03 no
2 4/4/03 yes
3 4/4/03 no
3 4/5/03 yes
Table2
JobNo Client City
1 MS NY
2 GTE LA
3 ATT NY
SO my final return on my query will look something like this:
JobNO Client City Comment Date
1 MS NY no 4/3/03
2 GTE LA yes 4/4/03
3 ATT NY yes 4/5/03
I am trying to create a join that will return the most current comment for each jobNo and list the client, city. There are no duplicates dates for each jobNo in Table 1. I have been trying the max date function but I get the max for the entire table and it only returns one row, I am unclear how to use the function using the JobNo as a qualifier.
Any direction would a great help
I have two tables that I am trying to join in MS Access and sort by a date and only return the most current date.
Table1
JobNO Date Comment
1 4/2/03 yes
1 4/3/03 no
2 4/4/03 yes
3 4/4/03 no
3 4/5/03 yes
Table2
JobNo Client City
1 MS NY
2 GTE LA
3 ATT NY
SO my final return on my query will look something like this:
JobNO Client City Comment Date
1 MS NY no 4/3/03
2 GTE LA yes 4/4/03
3 ATT NY yes 4/5/03
I am trying to create a join that will return the most current comment for each jobNo and list the client, city. There are no duplicates dates for each jobNo in Table 1. I have been trying the max date function but I get the max for the entire table and it only returns one row, I am unclear how to use the function using the JobNo as a qualifier.
Any direction would a great help