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...