report help

[accesshelpme]

i have never used a report in access before. I am trying to have all my client information desplay in one report. I want 4 columns in the report. client account name & version from a query/ and products and vendors from a different table not in the query. However some clients are not in the product vender table. I still want these clients in my report, but ide just like the product and vendor columns left blank.


Currently its just showing the ones located in the product vendor table in the report and not showing any of the ones that are not.

here is what i ahve as the rowsource for the report:

SELECT [Customer Account Details].[Client_Account_Name], [Client ProdVend].[Products], [Client ProdVend].[Vendors], [Customer Account Details].[Universe_Release_Version] FROM [Customer Account Details] INNER JOIN [Client ProdVend] ON [Customer Account Details].[Client_Account_Name] =[Client ProdVend].[Client_Account_Name];


any help would be greatly appreciated.

[June7]

Needs to be Right or Left join, not Inner. In the query designer double click the line connecting the tables and select the join type 'show all records from Clients ...'.

[accesshelpme]

i cant do that because the product/vendor table is not in the query. I cant add it to the query becaus of the way the datanase works.

[accesshelpme]

my row source now looks like this...still wont show a client if he is not in the prodvend table(so if he doesnt have a product or vender)
SELECT [Customer Account Details].[Client_Account_Name], [Customer Account Details].[Universe_Release_Version], [Client ProdVend].[Products], [Client ProdVend].[Vendors] FROM [Customer Account Details] INNER JOIN [Client ProdVend] ON [Customer Account Details].[Client_Account_Name] =[Client ProdVend].[Client_Account_Name];

[John_G]

Hi -

In your SQL above, change INNER JOIN to LEFT JOIN - that should work.

HTH

John

[June7]

Why can't you click on the link line? The query already shows a JOIN. There has to be a link line.

[accesshelpme]

oko the left hoin thing worked, thanks to both of u for your help!