Creating a query in design view

Hi Gillian,

I'm terribly sorry for the delay in getting back to you!

I have an answer for you though! Just checked with my colleague on the correct way to do this.

In your query criteria, use this:
Like "*2003"

You can also type *2003 and then press enter, it should turn it into the above for you.

Run the query and you should only see dates with 2003 as the year.

Alternatively, you can run a query with no criteria, select the text '2003' with your mouse under your date field, and press the Filter By Selection button on the toolbar.

See the attached screenshots for more detail.

I hope this answers your question. Please let me know if it doesn't by reply to this post, and I shall assist you further. If it's all good, please mark this post as resolved.

Thanks Gillian.

Regards, Rich