Quartile Function in Access

T

tennisbuck

New member
Local time
Today, 06:37
Joined
Aug 14, 2013
Messages
3
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
 
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....
 
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.
 
Try to Google for the words, (see if you use anything from that):
quartile calculation+code in ms-access
Click to expand...
 
You must log in or register to reply here.

Similar threads

M
Solved VBA form issues from a newcomer
2
Replies
22
Views
644
MediaHolic
M
N
Visualising data in Access
Replies
3
Views
482
tvanstiphout
T
N
QR Code In MS Access
Replies
1
Views
782
CJ_London
C
S
OOP in Access Applications
2
Replies
28
Views
1,094
Uncle Gizmo
Uncle Gizmo
D
Solved Nesting IIF Statement with functions that end in (field)
Replies
13
Views
429
arnelgp
arnelgp

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom