Query Join Properties and Filtering

[Edgarr8]

Hi,

Background:
I have 2 tables, One of them has a list of APN's and its description and the other table has the information about period when those APN's have been paid and what kind of tax it was.
Ex:

APN Table:

APN, County, Owner,Acres
123 Fresno Juan 10
546 Tulare Bob 20
879 Fresno John 15
897 Fresno Trace 30

APN Tax Table:

APN, Period, Tax, Tax Type, Amount
123 07/08 Secure 100
123 08/09 Secure 110
897 08/09 Secure 200


Thats similar to my tables,

Problem:
What i need to do in a query is be able to
pull up all the APNs but be able to filter by period and tax type.

Even if i have not entered any information about the APN in my "APN Tax Table"

So if i want to see all the "secure taxes for period 08/09 i would get


APN, Period, Type
123 08/09 Secure
546
879
897 08/09 Secure


Please help me find a solution

I have changed my Join Properties so it gives me every APN i have, but as soon as i apply a filter, it takes them away...I understand way it happens...but it there any way to change that?

 

[boblarson]

Create a query first from your second table which has the criteria based on period and what kind of tax it was. Then, you can join that query to the other table and use an outer join to select all from the first table and only those that match in the second table (your QUERY).

You can't have an outer join and put criteria on any fields in the table which is on the right side of a left outer join or on the table which is on the left side of a Right outer join.

 

[Edgarr8]

Thank you!
It worked
I'm so grateful for this forum!

 

[boblarson]

Glad we could help out