Search results

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

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

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