I have a Gridview using the table G/L Posted Transactions with this line:

{Fiscal Year} = "2015-",

How can I make that a query so that it will ask you to enter the fiscal year of your choice?

Hi Susan,

Use:
You can replace the "2015" in the formula with whatever default year is most appropriate for your default value.

Wow.. that actually works. Thanks. :-)

Another approach can be used in situations where there is a limited number of possible choices. If you were selecting specific starting and ending dates (ie. February 1, 2014 to December 31, 2014), there are thousands of possible combinations. But when selecting fiscal years, there is a limited number of possibilities: 2014, 2015, 2016 etc.

In that situation, you could simply create a filter for each year, specify the year directly in the filter and name it that way. You could create filters for the next 10 fiscal years in a couple of minutes.

Bruce's approach is better if there are only a few specific fiscal years to check for.

Thanks Bruce. Great idea. In this situation I am already using drop down filters for the different bank accounts, but that would work well in some cases.