F
Fysh
I am attempting to create a chart on a report. I have a couple queries
pulling in the information I believe I need. The final query is used to
populate the chart. Now I am trying to see if there is a way to use a
dropdown to get the maximum numbers of records shown. I have a table that I
am attempting to count each item missed on an evaluation. Then on a reports
form I have a dropdown value list 1-10 in which I am trying to populate a
chart on a report to show highest missed items. If I select 5 then it should
show the highest 5 and the amount if I select 10 then it should show 10 items
and the amount. Is this possible? Also, if 2 items are tied for fifth place
it should show 6 columns on the report not 5. How do I do this? Thanks in
advance
pulling in the information I believe I need. The final query is used to
populate the chart. Now I am trying to see if there is a way to use a
dropdown to get the maximum numbers of records shown. I have a table that I
am attempting to count each item missed on an evaluation. Then on a reports
form I have a dropdown value list 1-10 in which I am trying to populate a
chart on a report to show highest missed items. If I select 5 then it should
show the highest 5 and the amount if I select 10 then it should show 10 items
and the amount. Is this possible? Also, if 2 items are tied for fifth place
it should show 6 columns on the report not 5. How do I do this? Thanks in
advance