Selecting specific records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


John Daily said:
Running Access 2000
I have three tables that are linked by an account number. One table is
Click to expand...
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
Click to expand...
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.
 
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
 
Back
Top