0

I have a table with records that have start and end dates per record. I need to create a query that based on the start and end date puts the relevent value into a financial year. For example

| Record  fte     start               end      |
|----------------------------------------------|
| 1        3      01/07/19            30/06/25 |
| 2        2      01/07/19            30/06/20 |
| 3        1      01/07/19            31/10/19 |

Result

|           18/19    19/20    20/21    21/22    22/23   23/24 |
|-------------------------------------------------------------|
| Record 1             3        3       3         3       3   |
| Record 2             2                                      |
| Record 3             1                                      |

I need outer years to show as at 1/07/20xx I.e the start balance of that year. I have a query for current month for the current year. I am just not sure of the syntax for the query. This is in access.

Any help much appreciated.

  • 2
    If you "have a query for current month for the current year", then also post that query. Share as much as you have so that (1) other don't have to recreate what you have already done, and (2) they can reference what you have done so it is more relevant to your particular problem. As a general rule, you should always show what work you have done and not expect other to just give you a complete solution for "free". – C Perkins Jun 27 '19 at 5:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.