creating relationships cause data to not show..

[mike02]

this first set doesnt show the values still, and the second one shows the value for query F. As soon as I add in one more inner JOIN, it doesnt show the Data...

[JoeM]

OK, so the second one does show them?
Then i would recommend starting from there, and rebuilding your query, adding one table at a time.
After each addition, switch to datasheet view to make sure everything still exists.
If at some point along the way it does not, stop there and investigate - as that is where the problem is occurring.
If you are able to add them all in and all your fields still show, the problem solved!

[mike02]

Ok, so when I add one individually, It stops on the second one for showing data, I have tried every query mix, then when I change to one again, and cycle through those, I originally got nothing for every other query except query F, so then I went back to query F and I got nothing.

so that cant be right, so i continued trying things, and here is what happens.

Every time I change which (ONE) query to Inner Join, I have to save. And compact and repair the DB, and then open the query. IT then shows the data. So i tried to do that when adding 2 queries. No such luck.

I am completely baffled.

Any Ideas on how else I could set up these expressions in queries to do the same thing, but in a different way?

query A, B, C, D, E, F are IDentical, Just different Number drivers from tables fields.

These fields are then calculated into queries to find the values.

Current Issue:
The summary query where it summarizes the data, and uses expresions to match the client etc.

Then Report,

[JoeM]

Two things to try:

1. Change all your queries from Inner Joins to Left Outer Joins.

2. Try importing all your database objects into a new database. It is possible that your database has become corrupted, and doing that would usually fix it.