Chart displayed from query between two dates

G

Guest

Hi

I was wondering what my best course of action would be for the following
problem. I have a query that returns data from a database between two user
entered dates in a table form. Along with the table, I would like to be able
to display a bar chart of the data. The chart in the Office Web Components
does not allow for a filter to be applied over a range as far as I can tell.
It allows for specific days to be chosen but I would prefer if the website
did this automatically based on the dates submitted by the user. What can I
do?

Thanks
 
S

Stefan B Rusynko

See http://www.asp101.com/samples/bar_chart.asp

--




| Hi
|
| I was wondering what my best course of action would be for the following
| problem. I have a query that returns data from a database between two user
| entered dates in a table form. Along with the table, I would like to be able
| to display a bar chart of the data. The chart in the Office Web Components
| does not allow for a filter to be applied over a range as far as I can tell.
| It allows for specific days to be chosen but I would prefer if the website
| did this automatically based on the dates submitted by the user. What can I
| do?
|
| Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
Excel Changing chart label colors based on a value in a cell 0
real time graph in FP from MS Access query 7
Using Between Dates in a Query 4
Query between two dates applying grouping 5
Stacked Bar Chart 1
Using Access Queries in Excel 2
How to query a database between two dates? 7

Top