Working with a large data set and need a way to make it more usable.


Currently:
I have it programmed at the start it asks me for the [Lake Name]

After I type the lake name, I want to set it up to ask for the year of the survey. I want it to filter the surveys out by year, and not the exact date. Is there a way to write this in the criteria section?

Query .jpg


Example of the table I have:
vaw_name samp_sampleID samp_startdate
Sylvan 4325 7/5/1967
Sylvan 4324 7/5/1967
Sylvan 4322 7/5/1967
Sylvan 4327 8/24/1967
Sylvan 4330 7/20/1970
Sylvan 4329 7/20/1970
Sylvan 4328 7/20/1970
Sylvan 4331 6/5/1978
Sylvan 4335 6/11/1979
Sylvan 2682 6/2/1980
Sylvan 2687 6/1/1981
Sylvan 2688 6/3/1985
Sylvan 2689 9/10/1985
Sylvan 2703 6/2/1986
Sylvan 2706 8/25/1986
Sylvan 2710 10/8/1986
Sylvan 2712 10/7/1987
Sylvan 2713 10/26/1987
Sylvan 1033 6/3/1991
Sylvan 1036 5/4/1993
Sylvan 1038 5/18/1993
Sylvan 1039 8/16/1994
Sylvan 1040 6/3/1996



What I want ( If I searched for 1967):

vaw_name samp_sampleID samp_startdate
Sylvan 4325 7/5/1967
Sylvan 4324 7/5/1967
Sylvan 4322 7/5/1967
Sylvan 4327 8/24/1967