showing all records in a query

[hockey8837]

Hi,
I have two queries, 'LocationOfTreeWork' and 'FundingExtended.' I'd like to create a form which displays all locations, and any corresponding funding associated with that location.

I tried to create a query which pulled all info from both of these tables, with TreeworkID from query 'LocationOfTreeWork' with TreeWorkIDFK from the query 'FundingExtended' joined in the query.

However, this only displays tree work locations that have funding assigned to them, and not all tree work locations. I need to also be able to see those without funding so I know what projects still need assigned funds.

I've also tried to create one query and pull data from the 'Funding' table and the 'LocationOfTreeWork' query directly... but it still does not display all records of tree work.

Is there some other way I should be doing this?

 

[HiTechCoach]

Hi,
I have two queries, 'LocationOfTreeWork' and 'FundingExtended.' I'd like to create a form which displays all locations, and any corresponding funding associated with that location.

I tried to create a query which pulled all info from both of these tables, with TreeworkID from query 'LocationOfTreeWork' with TreeWorkIDFK from the query 'FundingExtended' joined in the query.

However, this only displays tree work locations that have funding assigned to them, and not all tree work locations. I need to also be able to see those without funding so I know what projects still need assigned funds.

I've also tried to create one query and pull data from the 'Funding' table and the 'LocationOfTreeWork' query directly... but it still does not display all records of tree work.

Is there some other way I should be doing this?

Try changing the Join Type to include all records from 'LocationOfTreeWork and only matching from FundingExtended.

TIP: Check out the Unmatched Query Wizard.

 

[hockey8837]

It worked!
That was too easy!
Thanks

 

[HiTechCoach]

It worked!
That was too easy!
Thanks

You're welcome!

Glad to assist.