Search results

Hi, I have now uploaded the file again. Thanks!

Hi, Please see attached file. I hope you will understand now :) The reason why I want it this way is because i want a history.

Yes and no!. If they are overlaping each other - calculate the new one. Eg. Old contract 1995-2020 New contract 2011-2020 Stop calculate the old contract at 2010 since the old contract got replaced. Any idea?

I'm @ work again. How would that solve it? I still would have two contracts? Thanks

Okay, now I have added an attachement of my query. Debitera=Invoice Sumofinbe...= How much the customer paid that year. They aren´t equal but that´s correct. Anyway, as you can see in the picture there will be two invoices becuase I have two contract. The old contract was from 2005-2020 and...

Im not home from work yet but yes, I need all rows. I`m only sending an invoice once a year. And the inoice is adjusted to cosumer price index. If i can get this query to work then i can look back in the past and by law i am able to invoice them ten years back. For example one customer paid to...

Yes, i will do that as soon im home frome work. Thanks a lot

Yes, I am. I want a history in my query. I just want to be able to add a new contract without changing the old one. Any ideas?

Hello, I have a table with invoices: ID| Start date | End date | fee 18 1999-01-02 | 2018-01-02 | 3000 18 2012-01-02 | 2018-01-02 | 5000 In my query i can see all years and what the fee has been. The problem is if customer has an old contract, example 1999-01-02 to 2018-01-02...

Thanks! I actually just did that. I inserted 2008 2009 2010 2011 2012 in another table. Then everything looked perfect I had every contract and calculated the invoice for the years above and compared it what they did pay that year. The problem is now, for example: If a contract is written...

Hi. I know how to do the price calculation (invoice table ) for todays year. But i would like to do the price calculation for every year in the past too, and then compsre it with what my customers did paid. So i will get a history. I have a table calles invoice: Name start.year end.year...

Hi. Hi want a form: Name , start date , end date After you have typed in the data above, the data should converts to a record for each year in a table. Example: Form: Sarah 2003-02-01 2004-02-01 Table: Sarah 2003 Sarah 2004

Or a form there you type in a date range which ends up with all the dates between in a table

Hi. I have a table with names. Start date. End date. For example : sarah 2007-03-04 2011-03-02 I want a query with a record (row) for each year. Thanks