criteria in DStdevP

[Ssstacey]

I have the following problem, which I think might be quite easy for some of u..( hoping u can help..

I want to use the DStdevP function, DStdevP("myfield","myquery", myproduct=myquery.product and between enddate and begindate)

However, in my database i distinguish between year and month. THis makes it difficult to impement the 'between enddate and begindate' criteria due to month that runs up till 12 and goes back.

I read somewhere that there is apossibility to use GROUP BY. Is this a solution? If so, how can I implement this? Or maybe someone knows how to formulate the criteria in a way that I dont get mixed up with the month.

Thank you in advance.
Stacey

 

[KenHigg]

I think the best way to do this is to get your records from a pre-built query that you can make work...

Make sense?