Selecting specific records

[John Daily]

Running Access 200
I have three tables that are linked by an account number. One table is Patient Info and the primary key is an account number (acct_num). The next table is Denial Codes; with the denial codes table there are multiple denial codes for each acct_num. Again this is linked to the Patient Info table by acct_num. The third table is Payment Info; it too is linked to the Patient Info by acct_num and the acct_num is primary key in this table. There is only one record per acct_num in this table
Question
How do I show only one account number with multiple denial codes? The problem I have is when I create a report I create a query first to pull the data from. I think this is where the problem is. My count info in the report is wrong because if the acct_num has multiple denial codes then when counting the acct_num will count it multiple times
I am trying to pull distinct data into the report and not duplicates

Can anyone lend me a hand

Thanks in advance

John

 

[Duane Hookom]

Place the denial codes in a subreport and remove them from the main report.
This works very much like a form and subform.

--
Duane Hookom
MS Access MVP

Running Access 2000
I have three tables that are linked by an account number. One table is

Patient Info and the primary key is an account number (acct_num). The next
table is Denial Codes; with the denial codes table there are multiple denial
codes for each acct_num. Again this is linked to the Patient Info table by
acct_num. The third table is Payment Info; it too is linked to the Patient
Info by acct_num and the acct_num is primary key in this table. There is
only one record per acct_num in this table.

Question:
How do I show only one account number with multiple denial codes? The

problem I have is when I create a report I create a query first to pull the
data from. I think this is where the problem is. My count info in the
report is wrong because if the acct_num has multiple denial codes then when
counting the acct_num will count it multiple times.

 

[John Daily]

Thank you Duane! Again you have helped me

I don't know why I didn't think of that before since I already do that in my forms

Thank you

John