Query based off of selected date

[cbende2]

Hello all,

I have a table named PlanTable with a field named [YearEnd]. It is the fiscal year end of plans... Ex. (3/31, 6/30, 12/31) The actual year is not present with this date as seen in the examples.

I'm building an append Query which allows the user to enter a date.. say.. 12/31/2015, and he will run the query. I want the query criteria to be only the month and day(12/31), not the year, since the year is not present in the table. However, when the query is made, I would like for the whole input from the user to be added to the [Year End], thus giving the result of 12/31/2015 in the new appended table.



I do not know VBA, so simple solutions are best.

Thank you very much!

[June7]

Why would only 2 records be appended?

Don't understand data structure. If you want to provide db for analysis, follow instructions at bottom of my post.