Hello!
I have tblCodes this has budget codes in (about 20 records)
I have tblBudget this has 3 fields (Date, Budget Code, Budget)
I need to create an append query so that I can add a new years budget to tblBudget using the budget codes from tblCodes, my problem is that I need to add a month and year next to each budget code then loop this for each month of the year, so it would look something like
Jan 2021 1.1 Travel
Jan 2021 1.2 Expenses
Jan 2021 1.3 Training
Feb 2021 1.1 Travel
Feb 2021 1.2 Expense
Feb 2021 1.3 Training
Mar 2021 1.1 Travel
Mar 2021 1.2 Expenses
Mar 2021 1.3 Training
Etc.....
I'd also need the facility to say what year it is for so I can make a 5 year budget....
Any good suggestions much appreciated!!
I have tblCodes this has budget codes in (about 20 records)
I have tblBudget this has 3 fields (Date, Budget Code, Budget)
I need to create an append query so that I can add a new years budget to tblBudget using the budget codes from tblCodes, my problem is that I need to add a month and year next to each budget code then loop this for each month of the year, so it would look something like
Jan 2021 1.1 Travel
Jan 2021 1.2 Expenses
Jan 2021 1.3 Training
Feb 2021 1.1 Travel
Feb 2021 1.2 Expense
Feb 2021 1.3 Training
Mar 2021 1.1 Travel
Mar 2021 1.2 Expenses
Mar 2021 1.3 Training
Etc.....
I'd also need the facility to say what year it is for so I can make a 5 year budget....
Any good suggestions much appreciated!!