J
jeremy0028
I'm Trying to create a charge report from a tbl called tblcharges
which has the following
ClaimID
PersonID
DOSFrom
DOsTo
Procedure
Fee
BillTo which is a combo box and has a macro event which is a requery
and the following sql code In this combo box patient
could have 2 insurances example Medicare which is Primary And Medical
which Is Secondary and this will be stored in the
tblPeopleInsurance.Type Field which are P = Primary and S= Secondary.
Lets Say I will select Medicare because this is the patient primary
insurance.
SELECT tblPeopleInsurance.GuaranterID, tblPeopleInsurance.PersonID,
tblPeopleInsurance.Type, tblPeopleInsurance.InsuranceName
FROM tblPeopleInsurance
WHERE (((tblPeopleInsurance.PersonID)=[tblCharges].[PersonID]));
When I Run the report it only shows the insurance selected from the
BillTo combo Box but i also want it to show the other insurances that
the patient has for example his medical insurance but cant figure this
one out.
Any Ideas Thanks
which has the following
ClaimID
PersonID
DOSFrom
DOsTo
Procedure
Fee
BillTo which is a combo box and has a macro event which is a requery
and the following sql code In this combo box patient
could have 2 insurances example Medicare which is Primary And Medical
which Is Secondary and this will be stored in the
tblPeopleInsurance.Type Field which are P = Primary and S= Secondary.
Lets Say I will select Medicare because this is the patient primary
insurance.
SELECT tblPeopleInsurance.GuaranterID, tblPeopleInsurance.PersonID,
tblPeopleInsurance.Type, tblPeopleInsurance.InsuranceName
FROM tblPeopleInsurance
WHERE (((tblPeopleInsurance.PersonID)=[tblCharges].[PersonID]));
When I Run the report it only shows the insurance selected from the
BillTo combo Box but i also want it to show the other insurances that
the patient has for example his medical insurance but cant figure this
one out.
Any Ideas Thanks