Query select year

[cktcPeterson]

I have a form with a combo box where a person can select a business.-This works
Next I want to have a drop down that they can select the grant year.

How would I sent up my query and drop down to display the following?

Year 1 (Date Range 10/1/20-9/30/21)
Year 2 (Date Range 10/1/21-9/30/22)
Year 3 (Date Range 10/1/22-9/30/23)
Year 4 (Date Range 10/1/23-9/30/24)
Year 5 (Date Range 10/1/24-9/30/25)

 

[The_Doc_Man]

Since this is obviously a fiscal year situation, you only need the starting date in the combo box. The ending date is that year plus 1 year, for which see the DateAdd function. Just pick the starting data of the fiscal year because the rest is known or computable.

 

[plog]

This has to do with 2 values:

1. The datasource that will use the drop down. What value do you need to use and how? You showed us what should be displayed, but what value should be used when a user selects an option. Is this drop down's value going into a table? Is it going to be used to filter the form? In either case when the user selects Year 1, what is the actual value you need to use in that other datasource?

2. The datasource you will use to populate the drop down. You need to create a query capable of producing 5 records, preferably with a field that can be used to calculate each value. What is the name of that datasource and field?