Date

A

Adam

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?
 
M

Maurice

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
 
Top