extract part of date field

[Todd F.]

I have 2 date fileds - 1 is a serial date 2 is a date with time stamp.

I am rusty to Access 2000 and need to get a clean month in a filed and I
also need a month and yr in a filed.

My goal is to do cross tabs a summarize on these dates. My data sets are to
big to jump out to excel or I would be done.

Having trouble with expression builder and really don't know best way to go
about this.

thanks for time Todd

 

[Dan Artuso]

Hi,
Look up DatePart() function in help. You can extract the month or year from any date.