Apologies but I am an Access Novice…
I have a contacts and tracking database that holds contact info and tracks people through interview processes for different roles/jobs.
I have a table named “Cand” which holds details of people from my “Contacts” table that are candidates for a particular role. It includes [ContactID], and [MandateID] as well as a unique [CandidateID]. The Contacts table holds all the usual contact info.
Every time a candidate is contacted or progresses through the interview process this is then logged onto a separate table “Candidate progress”. The Table contains the [candidateID], [RoleID], a lookup column [progress] for ‘telephone Notes’, ‘meeting’ or ‘interview’ etc and an action field [ReqAction] denoting the next action to be taken and most importantly a date/time field [progressdate] which logs the date and time of the action, telephone call or interview. It has an ID field [candprogressID] which is unique for each entry.
I am trying to produce a report that will produce a print out of each [candidateID] and when they were last contacted by [progressdate] omitting any previous entries, but which more importantly gives their progress through the system [progress] or if there is any action required [ReqAction]. I have tried to do this using a totals / group by query which is fine at giving me the last date that a [candidateID] was contacted but as soon as I try and add the [progress] or [ReqAction] field to the report I get duplicates because the query also groups the report by [progress] or [ReqAction] as entries here are different. I have looked at other threads and found some similar questions but my unique problem arises out of the fact that it is the combination of the [progressdate] and [candidateID] fields that that gives me the last contact.
Can anyone help! Thanks in advance.
Simon S
I have a contacts and tracking database that holds contact info and tracks people through interview processes for different roles/jobs.
I have a table named “Cand” which holds details of people from my “Contacts” table that are candidates for a particular role. It includes [ContactID], and [MandateID] as well as a unique [CandidateID]. The Contacts table holds all the usual contact info.
Every time a candidate is contacted or progresses through the interview process this is then logged onto a separate table “Candidate progress”. The Table contains the [candidateID], [RoleID], a lookup column [progress] for ‘telephone Notes’, ‘meeting’ or ‘interview’ etc and an action field [ReqAction] denoting the next action to be taken and most importantly a date/time field [progressdate] which logs the date and time of the action, telephone call or interview. It has an ID field [candprogressID] which is unique for each entry.
I am trying to produce a report that will produce a print out of each [candidateID] and when they were last contacted by [progressdate] omitting any previous entries, but which more importantly gives their progress through the system [progress] or if there is any action required [ReqAction]. I have tried to do this using a totals / group by query which is fine at giving me the last date that a [candidateID] was contacted but as soon as I try and add the [progress] or [ReqAction] field to the report I get duplicates because the query also groups the report by [progress] or [ReqAction] as entries here are different. I have looked at other threads and found some similar questions but my unique problem arises out of the fact that it is the combination of the [progressdate] and [candidateID] fields that that gives me the last contact.
Can anyone help! Thanks in advance.
Simon S