F
FJB
I am working with a case management system that uses an Access database
with 111 tables. I am trying to create a report for upper management
that requires me to show the case notes. There is a problem, however.
If there are more than one subject, the case notes are repeated for
each subject in the database. Each note is also marked with a
"counter" which changes when a new note is entered. In a report or
query, how do I only see the case notes for any subject when the
counter changes?
If John Smith is the primary subject, but Mary Smith, Charles Smith and
David Jones are also listed as subjects, the case notes entered for
John Smith will also be saved for Mary, Charles, and David. In the
report I only want to see the note once.
I am having to use multiple queries to obtain the information. I am
finding that the tables to do not always relate on similarly named
fields. Sometime the field is numeric, while in the other table it is
text.
Thanks in advance. I'll clarify anything needed.
with 111 tables. I am trying to create a report for upper management
that requires me to show the case notes. There is a problem, however.
If there are more than one subject, the case notes are repeated for
each subject in the database. Each note is also marked with a
"counter" which changes when a new note is entered. In a report or
query, how do I only see the case notes for any subject when the
counter changes?
If John Smith is the primary subject, but Mary Smith, Charles Smith and
David Jones are also listed as subjects, the case notes entered for
John Smith will also be saved for Mary, Charles, and David. In the
report I only want to see the note once.
I am having to use multiple queries to obtain the information. I am
finding that the tables to do not always relate on similarly named
fields. Sometime the field is numeric, while in the other table it is
text.
Thanks in advance. I'll clarify anything needed.