query year

[steve111]

hi

how do I put in the query so I just have to input the "year" for my report

so it just asks me the year

ie 2015

thanks
steve

 

[Mile-O]

Quick question, you're not using forms in this database, are you?

 

[steve111]

hi ,
yes , the orders form tells me when I received the order
of which I input 20/02/2015 for example

the orders database could be 3 years old but I just want the report to show me 2015
then next year 2016
I just saved asking beginning and end dates ( I think)

steve

 

[Mile-O]

You could do something as rough as entering [ENTER YEAR] into your query criteria.

Personally, I'd use a combobox on a form, with a selection of years, and let the user pick one of those years, then let the query refer to that combobox, like [Forms]![MyFormName]![MyComboBox]

 

[steve111]

ok , I will try to do that

thanks