I'm trying to extract Agreements from our database table dated 2003 only. I've clicked onto query, gone into design view of the table, but I'm unsure what to type as the criteria in order to extract agreements dated 2003 only? Typing 2003 or = 2003 doesn't work, so I'm obviously doing something wrong!

Please can you advise?

Many thanks
Gill

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

Attached files...

filter-method.gif
like-criteria-method.gif

Resolved, thank you!

Best wishes
Gill