Query select year (1 Viewer)

cktcPeterson

Member
Local time
Today, 11:23
Joined
Mar 23, 2022
Messages
73
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

Immoderate Moderator
Staff member
Local time
Today, 14:23
Joined
Feb 28, 2001
Messages
26,850
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

Banishment Pending
Local time
Today, 14:23
Joined
May 11, 2011
Messages
11,586
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?
 

Users who are viewing this thread

Top Bottom