Search results

I have two problems/questions: The first one: Can anybody give me a step by step guide on how to created linked boxes (or whatever you call them). With this I mean, in box one you choose the Product, in the second box you choose the plan, and so forth. I want to let the DB pre-select, so if you...

I have a problem with a function. I have entered it into the VBA windows and have done a debugging so the function should be fine. If I now want to use it in a query I get the "undefined function" error. In the query I type: Commission: CalCom([Products Complete].[Price Excl VAT]) And the...

Ok, I'll look into that combo box story, thanks. The suggestion you made would be quite difficult because it is not known when the policy will lapse. It should be a way so that it is assumed every month is paid and that only the months that aren't paid have to be manually adjusted.

Some Good news. The query is working and it shows the data as required. I thank everybody for the help. I would still appreciate it if somebody could answer that last question of mine.;) But at the moment, I'm very :D

Or if you just would have gone to the Microsoft website (I know, nobody likes to go there but in cases of emergency :) ) you would have found it. Also the help file will show you this information.

I have another question: Is it possible to let somebody for example enter a client ID and that the form or tabel shows the client first and last name?

Yep, more than one company, more than one branch. The reason why I changed the field from company ID to company number (because I had this in the beginning) was to allow easier entry for the data capturers (otherwise they have to remember 500 companies with their numbers, same for branches...

Okay, I'll change the names. The fact that there are two tables with the same name is something Access did. Because I already had a link between the two tables, and wanted to make a different kind of relation (no referential integrity) between the tables, Access put in the extra table. Can you...

Thanks, I'll try and normalize. If you want to see previous discussions i had with people about this problem including the SQL codes (although, then it was viewed as a query problem, not a DB relation problem) look here...

Hey, I'm having a strange problem nobody seems to be able to figure out and it is probably something small everybody (including me) overlooks. Here follows the discription: If I do a query in the table called 'Products Complete' the required results are shown. If, however, I add another table...

Let me put it back on top.

Could you tell me how you solved the problem? It could be useful for the future. Thanks

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

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.

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...

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...