Access 2010 query exact date from field

[Anathil]

Hi every one and thanks you for your help in advance

I have what seems to be a very simple problem.

I have a table with dates (Date) in a date/time format (dd-mm-yyyy)
and I have a form with an unbound field called "FindDateSpecific".

I am trying to build a query which would run when I press a button on the form with the unbound field.

My problem is that I cannot figure out how to set the criteria in the query to get the date I am writing in the unbound field in the form.

In the same form I have another unbound field called "FindYearSpecific" and in the same query I have:
Field - FindYearSpecific: Year([Date])
Table - Nothing
Sort - Nothing
Show - Check
Criteria: Like [Forms]![frmSearchGeneral].[FindYearSpecific] & "*"

This gives me all the records for the specific year I am after - If I write nothing it gives me every record in the table.
I want my FindSpecificDate field to work the same way.

In the form you should only fill one of the fields of cause But I want both options.

Anybody out there knows the solution? Please...

[jforbes]

I think this is a similar question:Query-Access 97 Pulling a Specific Year(s) of Data

There are a few different ways to Query against the Year part of a Date, but I typically use something like this:

WHERE Year(SomeYear) = [Forms]![frmSearchGeneral].[FindYearSpecific]

This uses the Year Function, but there is also the DatePart Function.

[Anathil]

Thanks jforbes :)

I might have written far to much information in this question.
Cause I think you misunderstood.

I have the year part down now (and thanks for you help there connecting the singe year with the between part).

My question here is for the entire date.

I want to be able to do exactly what I did with the years on date level.

Which mean that I want to be able to query for a specific date.

And hopefully afterward being able to combine that with a between date query to. But I think that might be two questions in a single thread ;)