Search results

I have a database which contains information on last year and this year (number of employees and premium charged). Would it be possible to have a query or module or anything else automatically copy the data that is in the present column to the prior column on a set date? Thanks

HELP with iif URGENT The first problem has to do with an iif function I am trying to figure out. I have asked this question before but the answer didn't work out for me. iif(format([Individual Policy Holders].[Date of first policy],”mm/yy”)=format(Date(), “mm/yy”), iif([Broker...

I need to do some calculations. These calculations will depend from several things. Firstly, it depends if the business is new or already exsiting. New business is business which has been achieved that current month. Than, it depends on weather or not the broker worked alone or if he/she also...

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

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

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