Query on a number field that adds 1

[Locopete99]

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.

 

[stopher]

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.

Maybe do it the other way round. Create a calculated field in your query that calculated the year they would need to enter e.g. EntryYr: FY_Year - 1. The you can just do the [?] in this calc field.

 

[Locopete99]

Hi,

I can get the expression to work, but I can't seem to get the [?] to work.

As soon as I start adding this in, the query stops returning records.

I've tried putting the [?] both o the expression line and then also on a seperate line under FY_year.

Please can you explain where I'm going wrong?

Hopefully if this pulls through I've attached a screen shot.

 

[Locopete99]

I've managed to fix it buy using the below in the field


Fy_YR: [Please Enter Year]+1