Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 12 Nov 2007 11:36 GMT

Hi

I'm new to Access. I'm using an Access table to record compliments that our
company receives. I have a column which lists the date that each compliment
is received. I would like to run a query that just holds compliments we
received in 2006. Please could someone help me?

Reply to this Message

Maurice - 12 Nov 2007 12:04 GMT

Adam,

In your query put the following in your criteria field under the date field:

Year([name of datefield])=2006

Replace the [name of datefield] with the appropriate name of your datefield

hth

Signature

Maurice Ausum

> Hi
>
> I'm new to Access. I'm using an Access table to record compliments that our
> company receives. I have a column which lists the date that each compliment
> is received. I would like to run a query that just holds compliments we
> received in 2006. Please could someone help me?

Reply to this Message