Quartile Function in Access (1 Viewer)

tennisbuck · Dec 21, 2013

Hi Board,

Really stumped and was hoping for some help. Most likely this has to be done in VBA and this is not my strong point in data analysis. I basically have a table in this format:

Sold To Marketing Name Total Sales Dollars
10009 Mufflers 100,000

My question is how would I create quartiles for each marketing name for the sold to's in that marketing name based on the sales dollars? Also are Fish Tail graphs a option in Access?

Thanks

Mike

namliam · Dec 21, 2013

fish tail graphs? Erm what?

Quartiles, you mean quarters as in 3 months periods?
Do you have a sales date of your sales? if so you can easily use Format or Datepart to transpose the date(s) into quarters, the group by quarter, perhaps use a crosstab too....

jdraw · Dec 21, 2013

There is no native quartile function in Access, nor fish tail/fish bone graphs.
You could create your own quartile calculation or function using the info here.

tennisbuck · Dec 21, 2013

Does anybody know how to create this function?

JHB · Dec 21, 2013

Try to Google for the words, (see if you use anything from that):

quartile calculation+code in ms-access

AlexHedley · Dec 21, 2013

Cross Post:
http://www.accessforums.net/showthread.php?t=40274

Quartile Function in Access (1 Viewer)

tennisbuck

New member

namliam

The Mailman - AWF VIP

jdraw

Super Moderator

tennisbuck

New member

JHB

Have been here a while

AlexHedley

Registered User.

Similar threads

Users who are viewing this thread