YTD by month from a drop down

[mindbender]

I have a drop down that contains all 12 months in a list. What I am trying to do is for example if the user selects march - the data returned woudl be YTD to March (Jan-Mar) or if the user selects August - the data returned woudl be YTD Aug (Jan-Aug)



Any help would be appreciated

Thanks

[burrina]

You can of course use a table/query as the record source or a value list with the month names. Up to you! Example in query below of YTD.

SomeField:>=DateSerial(Year(SomeDate()),1,1) And <=SomeDate()

HTH

[mindbender]

Thanks for the reply. I was hoping for somthing like the attached. Where they choose the month and the data returned is up to the last day of the month selected

[mindbender]

Here is the image I modified to show what I mean

[burrina]

I use this code for the form's record source.

AppliedPayments: Format([OrderDate],"myyyy")
'Criteria Below


[Forms]![frmSalesTax]![MonthID]

HTH