Criteria for last 12 months

[libraccess]

I have a report where I want to have two charts. So far I have one chart and a separate table showing stats for a specified time period. (I have a separate report form where dates are entered Normally monthly or quarterly). My first query in the datefield has this
Between [Forms]![frmReports]![txtStartDate] And [Forms]![frmReports]![txtEndDate] All works well

So now to my second chart, I want to display the last 12 months from my [textEndDate] and I want the months as Jan Feb etc and have tried quite a few combinations but i've reached my bestby date
my last attempt was
Between [Forms]![frmReports]!DateAdd("mmm",-12,[txtEndDate])And [Forms]![frmReports]![txtEndDate]
help please

[pbaldy]

You don't want to break up the form reference like that. Try

DateAdd("mmm",-12,[Forms]![frmReports]![txtEndDate])

[libraccess]

So are you saying the whole expression should be ?
Between DateAdd("mmm",-12,[Forms]![frmReports]![txtEndDate]) And [Forms]![frmReports]![txtEndDate]
because I get a message "Typed incorrectly or too long to be evaluated........try simplifying it" ?

[libraccess]

Sorry I'm back on the phone so quickly, I'm having a brain fade over this lot. Now I do not need this expression in the query right? so long as my report has the two parts in text boxes with control source set to each part of the expression. However my first part < DateAdd("mmm",-12,[Forms]![frmReports]![txtEndDate])> comes up with name? on the report. meanwhile I have to look at my chart to try and get Feb Jan Mar into an order that is not alphabetical
Thanks

[pbaldy]

Try with only 1 "m", which worked for me in a brief test. I would expect as the criteria of a query, though there could be other uses.

[libraccess]

Between DateAdd("m",-12,[Forms]![frmReports]![txtEndDate]) And [Forms]![frmReports]![txtEndDate]

Yes this gives me the results I want in the query thankyou
All I need to do now is translate that to the chart. I seem to find charts ddont always play the game especially when trying to get more than one chart and other info onto the same page of a report. ( I guess that is why there seem to be so many dashboard builder and similar around ??

Thanks again

[pbaldy]

Sorry, I don't do much charting. You might want to start a new thread on charting to get the attention of somebody with more experience in that area.