Empty field after query

[Fastone]

Hello,

I have a problem with the DB I'm currently creating. If I do a query which should show the sales per company or branch, I get a good result (products, units, etc.) with an exception for the price. The query doesn't show the price for the products sold.
The company details come from one tabel, the products come from another tabel and the common fields are linked using joined type, the second option.

Please help and if at all possible could the answer be kinda simple (I'm really new at this).

Thanks

Stijn

 

[Jon K]

Please copy and post the SQL statement (i.e. the SELECT statement in the SQL View of the query.)

 

[Fastone]

SELECT DISTINCT [Broker & Marketer].[Broker/Marketer Number], [Broker & Marketer].[First Name], [Broker & Marketer].[Last Name], [Individual Policy Holders].Product, [Individual Policy Holders].Age, [Individual Policy Holders].Plan, [Individual Policy Holders].[Unit Number], [Enter Commission percentage in decimals (20%=0,20)]*[Products Complete]![Price Excl VAT] AS Commision
FROM (([Individual Policy Holders] INNER JOIN ([Broker & Marketer] INNER JOIN Branches ON [Broker & Marketer].[Branch Name 1] = Branches.Branch) ON [Individual Policy Holders].[Branch Name] = Branches.Branch) INNER JOIN Company ON Branches.[Company Name] = Company.Company) LEFT JOIN [Products Complete] ON ([Individual Policy Holders].[Unit Number] = [Products Complete].Units) AND ([Individual Policy Holders].Age = [Products Complete].Age) AND ([Individual Policy Holders].Plan = [Products Complete].[Product Plan]) AND ([Individual Policy Holders].Product = [Products Complete].[Product Name])
WHERE ((([Broker & Marketer].[Broker/Marketer Number])=[Enter Broker/Marketer Number]));

I hope this will make you any wiser so you can help me because I'm really desperate for the moment. Please let me know if you need any other information.

Thanks

 

[Jon K]

Try changing:
[Products Complete]![Price Excl VAT]

To:
[Products Complete].[Price Excl VAT]

 

[Fastone]

I changed the ! to a . but this didn't change anything when I ran the query.
If anybody has any other suggestions, please let me know.

 

[Fastone]

Is there nobody who has any other suggestions?
Please, any information would be appreciated.

 

[Fastone]

Let me put it back on top.