Dates in Query

[Guest]

I have a table with a date field called [Date Reported]. I have a query
where I would like to roll up all the dates by period and month. All entries
in May 2006 should all be returned as "5/1/2006", regardless of what date in
May it was in.

Thanks!!!

 

[fredg]

I have a table with a date field called [Date Reported]. I have a query
where I would like to roll up all the dates by period and month. All entries
in May 2006 should all be returned as "5/1/2006", regardless of what date in
May it was in.

Thanks!!!

Period: Format([ADate],"m/\1/yyyy")

or..

Period: DateSerial(Year([ADate]),Month([ADate]),1)

 

[Guest]

PERFECT!!! That is exactly what I wanted. THANKS!!!!!!!

I have a table with a date field called [Date Reported]. I have a query
where I would like to roll up all the dates by period and month. All entries
in May 2006 should all be returned as "5/1/2006", regardless of what date in
May it was in.

Thanks!!!

Period: Format([ADate],"m/\1/yyyy")

or..

Period: DateSerial(Year([ADate]),Month([ADate]),1)