MS Access

[mangobreeder]

ok i have a date field in Access (field 1)

i want another date field field (2) which will show a date, which is the next quarter end,

eg.
Field 1 Date Field 2 Date
01/02/09 31/03/09
02/02/09 31/03/09
13/03/09 31/03/09
01/04/09 30/06/09
11/05/09 30/06/09
11/08/09 30/09/09
01/10/09 31/12/09

how do i go about it?

 

[SimonCHere]

Google anyone? ("MS access" date quarter)

DatePart("Q",[Field 1])
brings back quarters


DateSerial(Year([Field 1]), 3*DatePart("q",[Field 1])-2, 0)
Should give the date of the quarter

 

[GravyMonster]

*edit*
Far too slow - Simon's answer is much nicer.

 

[mangobreeder]

thanks