Charting data

Question

Hi,

I have this data set, and I want to have a bar chart with the columns,

one column for <3,

second column for 3-6,

third column for > 6

see below.

Any ideas  how this may be achieved in Access charts? 

Thanks in advance.

John

---

JG

Answer 1

Hi,

you could use a query like this as the basis of the chart:

SELECT IIf([InvLength]<3,[InvLength]) AS [>3 months], IIf([InvLength] Between 3 And 6,[InvLength]) AS [3-6 months], IIf([InvLength]>6,[InvLength]) AS [>6 months]
FROM MyTable

or already including the counts:

SELECT Count(IIf([InvLength]<3,[InvLength])) AS [>3 months], Count(IIf([InvLength] Between 3 And 6,[InvLength])) AS [3-6 months], Count(IIf([InvLength]>6,[InvLength])) AS [>6 months]
FROM MyTable

Depending on what kind of chart you use (there are new or old charts) you will have to do some more work but the fitting data should be available now.

---

Karl
http://www.AccessDevCon.com
http://www.donkarl.com/?AEK

Answer 2

A thing of beauty .... Thanks Karl D.

---

JG