Query Access Database for Customer record that Changed a condition

Hi Experts,
Have 2 databases:
C:\Access\billing\billing.mdb
C:\Access\prospects\prospects.mdb

A table exists in each database name "Customers"

If a customer is no longer active the status field is marked "Cancelled"  A button on the Prospects.mdb database lets me append all records that are marked "Cancelled" to the Prospects.mdb Customers table.

Please help me write a query that will let me Select all customer table records from the billing database that has the same Lastname, Firstname, Address of records in the Customer table of the Prospect database AND where the Billing Database has the Customer.status field now marked ACTIVE.

Customers who leave sometimes return and they should not be contacted by salespeople.

Thank you.
Alex

Attached is the beginning of the query I started.Start Free Trial

1:
2:
3:

"SELECT Customer.Last, Customer.First, Customer.Billaddress, Customer.Phone, Customer.Billstatus
FROM Customer IN 'c:\access\billing\billing.mdb'
WHERE last = customer.last AND Billstatus = 'Active'"