Locopete99
Registered User.
- Local time
- Yesterday, 19:47
- Joined
- Jul 11, 2016
- Messages
- 163
Hi,
I have a query whereby I have a [?] in the Year field so that the user selects the year.
The query then selects the data dependant on the month.
The data needs to conform to the financial year, so January to March would be year +1.
However, when i set my criteria as [?]+1 (just guessing here) it doesn't work.
The year field is set as a number field.
Can someone let me know the right way to do it.
I have a query whereby I have a [?] in the Year field so that the user selects the year.
The query then selects the data dependant on the month.
The data needs to conform to the financial year, so January to March would be year +1.
However, when i set my criteria as [?]+1 (just guessing here) it doesn't work.
The year field is set as a number field.
Can someone let me know the right way to do it.