Statistical Quartile Data

[jlnewbie]

Is there a function or expression in Access that will return the 1st and 3rd Quartile of several records. I am able to do this in Excel with no problem but once I send my data to Excel it becomes more difficult to manipulate. . I'd like to do this preferably in a select query. Please be gentle I'm a newbie to VBA and SQL.

Thanks [sig]<p>JLopez<br><a href=mailto:Lopez31@ATC-Enviro.com>Lopez31@ATC-Enviro.com</a><br>Environmental Services @ Your Service[/sig]

 

[Amiel]

This question remains unanswered for some reason. I think that perhaps you should define the term : 'Quartile', used here.

I would like to assume that this means, 'calendar quarter'. Please clarify; I think that you may get a useful response to your post.

[sig]<p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br> [/sig]

 

[jlnewbie]

Thanks Amiel:
I got my answer and I posted it in the general discussion also. I should done it here also. To get the XPecentile or Quartile of any series of numbers the following web page outlines the function

http://www.mvps.org/access/queries/qry0019.htm

[sig]<p>JLopez<br><a href=mailto:Lopez31@ATC-Enviro.com>Lopez31@ATC-Enviro.com</a><br>Environmental Services @ Your Service[/sig]