Case Statement Syntax

[allenjasonbrown@gmail.com]

I posted this in the query section but maybe I need to post it in the programming section as I have to beleive someone can help me with the proper syntax for a case statement??



I am trying to figure out the proper syntax for a case statement using between/to dates.

I have 1 field with a date and would like to set another field to a period.

case field1
when field2 between 01/01/09 and 01/31/09 then = 'Y09P01'
when field2 between 02/01/09 and 02/31/09 then = 'Y09P02'
etc.....
end

[pbaldy]

It appears to be getting answered there, so it would be best to keep everything on that thread:

https://www.accessforums.net/queries...ment-9330.html