Writing a Critera for my query

[tsdpurdue]

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

[MarvinP]

Hi tsd,

You need to build an expression in your query builder FIELD that filters out the year only.
I have a large genealogy database with everyone's date of birth in a DOB field. If I want filter everyone who was born in 1955 I need to extract the year from the dob.

In a field in the query builder my formula looks like this:

Expr1: Year([People Table]![BIRTHDT])

Then in the criteria field I would then put "1955"

When I bang the filter it then only shows people who were born in 1955.

read about "Access Expression Builder" at:
https://msdn.microsoft.com/en-us/lib...or=-2147217396