formatting the Date

[WaltLukeIII]

I have a date field that I want to limit to the year. I format the field in the table. however when I access that table through a query the format reverts back to the typical month day and year format. I want to limit the data by years.

Thanks
Walt III

Walt III
SAElukewl@netscape.net

 

[PHV]

In your query simply select the year:
SELECT Year([date field]) AS [year]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[WaltLukeIII]

Thanks PH

That was exactly what I was looking for.

here is the syntax for the design veiw

Column_Name: Year(table.Date)

Walt III
SAElukewl@netscape.net