Missing Data from Joins

[jband]

I currently have query that looks at 2 tables that hold financial information. I am querying the data to do some adding and subracting based off a financial class of a facility. The issue I am having is that one table may have a financial code that the other does not have but I still need to show that financial class for the facility.

My looks as follows

FROM [CashValue Link] INNER JOIN TCashValue ON ([CashValue Link].FINANCIAL = [TCashValue].FINANCIAL) and ([CashValue Link].Date1 = TCashValue.Date1) AND ([CashValue Link].FACILITY = TCashValue.FACILITY) AND ([CashValue Link].CLT = TCashValue.CLT)

I am sure I am over looking something

 

[RainLover]

Re do your query using the query builder.

Once you get that correct which is a lot easier than writing it go to SQL view so you can do a copy pate to where you want to use if. When you paste it, it may require some minor adjustments.

HTH

 

[jband]

i Figured it out. I did the relationship wrong between the 2 tables. Must of been a brain fart on my end.:banghead: