Can someone help me with this Access/Visual basics question. I need syntax that will allow me to show the start date of each month and the last day of each month that a particular date falls into. For example if my record date was in 04/16/09, I need the month start date and month end date to show on separate cells through expression builder. Example is below
04 01 09 and 04 30 09
04 01 09 and 04 30 09
Thanks
Kevin