Year sorting

[User Name]

How do I prompt a user to enter in a number of years like 1974, 1975, 1978 and 1985 and then bring up only the data from these years in a query. The format that I have to relate the date to is issue date and it is in the format dd/mm/yr. Anyone have any suggestions.

 

[llkhoutx]

Why not use a combo box to select the year and then also in the criteria or Master link for the data.

 

[Pat Hartman]

If your date is stored in a field defined as a date/time data type, there is no problem. Just use the Year() function to obtain the 4-digit year.

Select ....
From YourTable
Where Year(YourDate) = [Enter Year];

 

[IgorB]

Your date format is dd/mm/yr.
Should be dd/mm/yy.

 

[User Name]

yr/yy same thing. Does anyone have a copy of a macro that gets the user to enter in a number of years ranging from 1971 to 2003 and gets them to choose a report for the info to go into then opens the report for the user with the wanted years information.

 

[Pat Hartman]

You'll need code. A macro won't do it. See this article from the knowledgebase. Even though you are not using a listbox, you can use the same technique to build the criteria string.

How to Use a Multi-Select List Box to Filter a Form