Filtering a continuous form with multiple criteria

C

Cravaus

I have a continuous form based upon a query that combines information from
three tables: PatientDemographic, DiagnosisData, InsuranceCompanies,
BillingData

I want a button on the form that will filter the following:

SELECT (All Latest (or most recent) BillingData.[BillingTotal](Currency) for
each BillingData.[chartnumber], and all BillingData.[BillingTotal](Currency)
WHERE BillingData.[Recubmission](yes/no =TRUE)) WHERE PatientDemographic.
[ActiveAccount] (yes/no = TRUE)

How would I code this? I can do each individually but I am lost when I try
to put it all together.

Craig
 
Top