Graph

[mavisyew]

Hi All,

I created a report with a graph but it only show the first 4 data for my report.
please see attached image.
Can anyone advise?

[June7]

No idea, not enough info. If you want to provide db for analysis, follow instructions at bottom of my post.

[mavisyew]

Hi June7,

Please find attached for the database.

Thanks for your help.

[mavisyew]

Hi All,

I noticed those with 1 and above not showing in the chart.
Not sure why, but my query is generating those with 2 cases.

[June7]

I think the issue is the Master/Child Links of the graph control. Remove them.

[mavisyew]

Hi june7,

i have remove move the master and child link but the graph become empty.

[June7]

Don't know why. That's all I did with your db and works for me.

[June7]

I notice you have dates formatted for dd/mm/yyyy. This is not Access standard (mm/dd/yyyy). Entering criteria as dd/mm/yyyy could be an issue. Review http://allenbrowne.com/ser-36.html

[mavisyew]

Hi June7,

You are right. Is working now.
I think i have deleted the wrong thing earlier.

Thanks for your help.