W
Will
tblAccounts is main table with fields such as...
idAcct
AccountName
AccountCity
AccountPhone
etc
tblHistory contains a history of all prior contacts with the Account. There
is one record per contact. Some fields are...
idAcct
idHist
Date Date contact with the account was made
ContactNote Notes about the contact
Contact Type Called, Call-In, Site_Visit, etc
NextDate Next date to contact the account
NextToDo What to do next
We want to create a query that shows the name of each account and only the
most recent history record for that account.
but if we put field from the two tables into a single query we get one query
record for each history record... so accounts with say... 10 prior contacts
recorded... will have tine records returned by the query.
How can we only have the most recent contact record returned along with the
account name?
thanks for any help.
idAcct
AccountName
AccountCity
AccountPhone
etc
tblHistory contains a history of all prior contacts with the Account. There
is one record per contact. Some fields are...
idAcct
idHist
Date Date contact with the account was made
ContactNote Notes about the contact
Contact Type Called, Call-In, Site_Visit, etc
NextDate Next date to contact the account
NextToDo What to do next
We want to create a query that shows the name of each account and only the
most recent history record for that account.
but if we put field from the two tables into a single query we get one query
record for each history record... so accounts with say... 10 prior contacts
recorded... will have tine records returned by the query.
How can we only have the most recent contact record returned along with the
account name?
thanks for any help.