problem in my query

[eran185]

hey again...

i try to build a query based on table and some other queries.

when there was only a table - it was ok (all the records were in my query).

but when i combine some queries - it wasn't ok... i didn't see all the records.

why ???

 

[raskew]

Hi -

Very likely an incorrect join between your table and other queries. Why don't you post your code so we can take a look.

Bob

 

[eran185]

example

hey
there is an example.
i build the query - main , that base on table (main) and query (balance) , but when i want to use the query - main , it's not work

 

[boblarson]

Of course you won't see data. Your balance table has nothing in it, and with a Left Inner Join (what you currently have) you won't see anything unless your balance table has data in it.

If you want to see all data in the main table and balances to go with that, you need to change it to an Outer Join. Double click on the link between the query and table in your main query. Select the second option - Select all records from Main and records from ...etc.

 

[eran185]

...

hey bob
i think i miss something ...

 

[boblarson]

 

[eran185]

.

hey bob
it's work ok
thank u very very much