table and query results

[slimjen]

All, using access 2013. I have a query from a table that I want to join in another table to pick up the sub accts for customers based on custid and state. Ex.
qrycust

custid custstate
 cust1234 VA

tblcustsub

qrycustid qrycuststate
cust1234  VA
cust1234A  VA

Desired results:
qrycustsub

qrycustid  qrycuststate
cust1234  VA
cust1234A  VA

qrycust are the results from tblcust filtered by some criteria. tblcust does not contain the sub accts for customers. the sub accts are only in tblcustsub. I want all the customers in the qrycust and only matching from the tblcustsub but also the sub accts listed in the Desired results example. My query now only picks up the custid but not the cust sub accts because I don't have the sub accts in qrycust. How can I acheive the results I need?

[ranman256]

You can backfill the master table...
run a query to pull only the custID from the child table,
put these in the master table with an append query.
now the master table has ALL custIDs, so join the 2 tables and get the child records.

[slimjen]

Thanks. Was trying to avoid manipulating the master table but makes since. Thanks again.